Home » RDBMS Server » Server Utilities » SQL loader
SQL loader [message #74257] Sun, 24 October 2004 23:58 Go to next message
usha
Messages: 20
Registered: December 2000
Junior Member
I have table

t(col1, col2,col3)

col2 may or may not contain values....

how do i do it.My control file looks like

load data
infile x.dat
replace
into table t

fields terminated by X'9' optionally enclosed by '"' trailing nullcols
        (col1 decimal external,
         col2 char,
         col3  decimal external)
i cant use filler.what r the the other options...

Thanks in advance

Report message to a moderator

Re: SQL loader [message #74261 is a reply to message #74257] Mon, 25 October 2004 23:20 Go to previous message
Barbara Boehmer
Messages: 9100
Registered: November 2002
Location: California, USA
Senior Member
Get rid of the :

optionally enclosed by '"'

Report message to a moderator

Previous Topic: Error:ORA-01034 : Oracle not available.
Next Topic: SQl * Loader
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 12 14:16:22 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.