| query regarding sqlldr [message #213084] |
Tue, 09 January 2007 07:39  |
sandeep.mullangi
Messages: 1
Registered: January 2007
|
Junior Member |
|
|
hi
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.
eg:
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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
