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)
Previous Topic: SQL Loader + report ++headline+footnote+logical record
Next Topic: An unknown service name
Goto Forum:
  


Current Time: Sat Jan 11 05:42:15 CST 2025