Home » RDBMS Server » Server Utilities » query regarding sqlldr
query regarding sqlldr [message #213084] Tue, 09 January 2007 07:39 Go to next message
Messages: 1
Registered: January 2007
Junior Member

i need to insert records into one table from a delimited text file using sqlldr.

but the problem is, i don't need all the fields in the text file to insert into table.

The structure of the text file is:

[ssn Name job comp_name sal ]
7782, "Clark", "Manager", "amdocs", 2572.50

i hav table with 4 columns. i.e. ssn, name, job, sal (excluding comp name)

while inserting the above record into the table, i need to skip that comp name field using sqlldr.

how to skip this n what to mention in the control file.

Re: query regarding sqlldr [message #213120 is a reply to message #213084] Tue, 09 January 2007 09:42 Go to previous messageGo to next message
Messages: 25571
Registered: January 2009
Location: SoCal
Senior Member
when all else fails, you could try reading the fine Utilities Manual
Re: query regarding sqlldr [message #213788 is a reply to message #213084] Fri, 12 January 2007 05:26 Go to previous message
Messages: 18
Registered: January 2007
Junior Member
Hi Sandeep,

to exclude comp_name, you can put filler for comp_name in control file.

comp_name filler

hope this will help you.

Previous Topic: Imoprt and Export
Next Topic: SQL Loader question: How to use two WHEN clauses for a single table load
Goto Forum:

Current Time: Sun Aug 20 03:02:01 CDT 2017

Total time taken to generate the page: 0.01577 seconds