Adding A Where Clause In 9i Export Utility For Exporting Specific Rows Fron Command Prompt
:Numeric Column Filter
The Above Statement Will Export All Records From Both Tables Matching The Condition
:String Column Filter
The Above Statement Will Export All Records From Emp Table Matching The Condition
:Numeric Column Filter
C:\Export> Exp Userid=Scott/Tiger File=Scott1.Dmp Tables=(Dept,Emp) Query='Where Deptno=10'
The Above Statement Will Export All Records From Both Tables Matching The Condition
:String Column Filter
C:\Export> Exp Userid=Scott/Tiger File=Scott1.Dmp Tables=Emp Query='Where JOB=\'MANAGER\''
The Above Statement Will Export All Records From Emp Table Matching The Condition
تعليقات
إرسال تعليق