-
SQL loader & TAB delimited data file
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|