Home » RDBMS Server » Server Utilities » Import to 1 colunm
Import to 1 colunm [message #72122] Wed, 12 March 2003 08:15 Go to next message
Elon Albuquerque
Messages: 2
Registered: March 2003
Junior Member
Is there a way to import mulpiple colunm off a file to only one colunm in the table?
Ex:

Data File:
A&#124B
C&#124B

Control file
append
insert into table_name
fields terminated by "&#124"
colunm_name (01:02)

A,B,C,D has the same type, I want to import this 2 colunms from the file to the colunm_name.
Re: Import to 1 colunm - HELP [message #72125 is a reply to message #72122] Wed, 12 March 2003 12:48 Go to previous message
Elon Albuquerque
Messages: 2
Registered: March 2003
Junior Member
No Message Body
Previous Topic: SQL*Loader: Loading Data with Carriage Returns/Line Feeds
Next Topic: problems installing 8i on pentium IV
Goto Forum:
  


Current Time: Tue Dec 24 07:45:08 CST 2024