| How to specify to load all columns [message #71566] |
Sat, 23 November 2002 23:55  |
Vivek Somani
Messages: 1
Registered: November 2002
|
Junior Member |
|
|
Hi,
In the control file of SQL loader, I do not wish to specify the column names. All the columns in the csv files are to be laoded. The cols in the database is also equal to columns in csv.
There are too many cols in the table to be loaded and mentioning each col name by name is a big pain...
Any help pls !!
|
|
|
|
| Re: How to specify to load all columns [message #71579 is a reply to message #71566] |
Mon, 25 November 2002 08:36  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
i dont think, there is a way to do it.
becuase in most cases, u need some kind of formating applied.so, specifieng columns WAS THE STANDARD.
but mentioning the columns should not be a big deal!.
describe the table in sqlplus , copy columns & paste it here.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
