OraFAQ Forum: Server Utilities » sql loader control file using tab as a delimiter

Home » RDBMS Server » Server Utilities » sql loader control file using tab as a delimiter

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sql loader control file using tab as a delimiter [message #69085]

Fri, 26 October 2001 22:20

sasikala reddy
Messages: 1
Registered: October 2001

Junior Member

I would like to get some hlep regarding this. Whn i'm using Tab as a delimiter in control file the data is not getting loaded. Any workarounds for this. Is there any toher way other than using 'Terminated by whitespace' clause

----------------------------------------------------------------------

Report message to a moderator

Re: sql loader control file using tab as a delimiter [message #69104 is a reply to message #69085]

Tue, 30 October 2001 10:51

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

LOAD DATA
INFILE 'ss.TXT'
APPEND
INTO TABLE fgh
FIELDS TERMINATED BY 't'
trailing nullcols
(s1,s2,s3)

----------------------------------------------------------------------

Report message to a moderator

Re: sql loader control file using tab as a delimiter [message #70929 is a reply to message #69085]

Thu, 15 August 2002 09:06

Neha
Messages: 20
Registered: July 2000

Junior Member

I tried loading the data using 't'
It works but it also skips the null data in a column and loads the next available data into the null data column
e.g.; 222 rrr <"null"> ggg

it loads ggg in the third column. I want null value there. NULLIF BLANKS doesn't work
ANy ideas???

Report message to a moderator

Re: sql loader control file using tab as a delimiter [message #73226 is a reply to message #70929]

Fri, 05 March 2004 01:40

Aldo Valerio
Messages: 7
Registered: March 2004

Junior Member

Did you find a solution to this? I'm having the same problem.

Report message to a moderator

Re: sql loader control file using tab as a delimiter [message #73241 is a reply to message #73226]

Sat, 06 March 2004 13:30

Barbara Boehmer
Messages: 9097
Registered: November 2002
Location: California, USA

Senior Member

For a tab-delimited input file, in your control file, use:

FIELDS TERMINATED BY X'09'

Report message to a moderator

Previous Topic:	inserting SYSDATE in a table column while creating a control file to load data using SQL loader
Next Topic:	how to store images using clob in oracle 8.0

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 29 05:04:11 CDT 2024