Home » RDBMS Server » Server Utilities » Re: Line Breaks while uploading the data using SQL*Loader
Re: Line Breaks while uploading the data using SQL*Loader [message #368343] |
Wed, 22 November 2000 11:00 |
Joe
Messages: 138 Registered: November 1999
|
Senior Member |
|
|
yes if the records are not fix then you wanna use a delimiter named � like (,:;...)
A not commun caracter to share record in your datafile.
after that us this clause below controlefile
insert into table ***
fields termined by "�" optionally enclosed by "'"
trailing nullcols
(col1,col2)
|
|
|
Goto Forum:
Current Time: Sat Jan 11 05:42:15 CST 2025
|