Query parameters in the EXP parameter

zhaozj2021-02-16  51

Query parameter is used to take the data of the criteria, format

WIN: Exp Test / test query = 'where name =' 'test' 'Tables = Tab1 file = Tabl1.dmp log = Tab1L

UNIX: Exp Test / test query = / "where name = / 'test /' /" TABLES = Tab1 file = tabl1.dmp log = tabl1

But it also has limitations:

Query can't be multiple table associations, such as this format

Exp Test / Test Query = 'WHERE Name =' 'Test' 'and Tab1.id = Tab2.id' Tables = (Tab1, Tab2) File = Tabl1.dmp Log = Tab1L

However, Query can be used to constrain the data export of multiple tables, provided that these tables have the same field, and these fields are used as the export condition:

Exp Test / test query = 'where name =' 'test' 'Tables = (tab1, tab2) file = Tabl1.dmp log = Tab1L

转载请注明原文地址:https://www.9cbs.com/read-19522.html

New Post(0)