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: Thu Mar 28 09:12:49 CDT 2024