SQL loader: Do any one know how to put "TAB delimited" reference at control file for TAB delimited data file..
Printable View
SQL loader: Do any one know how to put "TAB delimited" reference at control file for TAB delimited data file..
I have done it in the past and it sure works...I don't remember the exact syntax.
Try:
insert into table xxx
FIELDS TERMINATED BY ""
I have done it in the past and it sure works...I don't remember the exact syntax.
Try:
insert into table xxx
FIELDS TERMINATED BY "(tab)"
or
replace
( with <
) with >
OK! Thanks for your reply, but I found it and it will as follows:
'FIELDS TERMINATED BY WHITESPACE'
OraMan
OCP Oracle8, 8i, 9i