Home » RDBMS Server » Server Utilities » a simple question about sqlload
a simple question about sqlload [message #69270] Sat, 01 December 2001 09:55 Go to next message
w j
Messages: 4
Registered: November 2001
Junior Member
hi,
i have the kind of data below:
23, 3434, 3643636234, ,agf51
...
now how to load it because in the fourth column,
it is a space character. how to use the
'terminated by ...'command in control file?

thank you very much!!!

----------------------------------------------------------------------
Re: a simple question about sqlload [message #69271 is a reply to message #69270] Sun, 02 December 2001 10:56 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
use
field terminated by ','

----------------------------------------------------------------------
Re: a simple question about sqlload [message #69273 is a reply to message #69271] Sun, 02 December 2001 11:02 Go to previous messageGo to next message
wj
Messages: 1
Registered: December 2001
Junior Member
i used this, it doesn't work
and the rows with 'space' were rejected.

----------------------------------------------------------------------
how to load data file of unix environment into oracle with commands as well as example [message #70067 is a reply to message #69270] Mon, 08 April 2002 03:38 Go to previous message
anjanik kumar
Messages: 1
Registered: April 2002
Junior Member
tell me how to convert simple data file of unix environment to oracle table
Previous Topic: Extend rollback segment
Next Topic: flat file --- its urgent
Goto Forum:
  


Current Time: Mon Dec 05 07:56:28 CST 2022