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)

Report message to a moderator

Previous Topic: SQL Loader + report ++headline+footnote+logical record
Next Topic: An unknown service name
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Aug 04 04:31:10 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.