OraFAQ Forum: Server Utilities » Sql Loader: How to insert only selected fields from a CSV file to an Oracle Table

Home » RDBMS Server » Server Utilities » Sql Loader: How to insert only selected fields from a CSV file to an Oracle Table

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

Sql Loader: How to insert only selected fields from a CSV file to an Oracle Table [message #71216]

Wed, 25 September 2002 04:52

Shri G
Messages: 3
Registered: September 2002

Junior Member

Hello,

Can you insert only the selected fields (columns) from a comma delimited text file (CSV)into an Oracle table. The input CSV file is a single source for the data which needs to be updated into multiple tables in Oracle.

Example;
Infile: temp.csv
col1,col2,col3,col4.......,col15

Oracle Table: Dummy
col1,col4,col5,col6

My question is how do I insert only the column col1,col4,col5,col6 into the oracle table Dummy using sql loader.

I would appreciate your kind feedback. Thanks,

Shri
(vardhan99@yahoo.com)

Report message to a moderator