| SQL loader -Control file with header [message #168178] |
Wed, 19 April 2006 03:47  |
oracle.g
Messages: 12
Registered: October 2005
|
Junior Member |
|
|
Hi,
My control file is like this:
col1|col2|col3
1|a|red
2|b|yellow
The 1st line is the header record col1,col2,col3 are the names of the column of table.
Depending on the header i have to insert.
Should not process based on the delimiter.
Table
-----
col1 col2 col3
1 a red
2 b yellow
Thanks
|
|
|
|
|
|
| Re: SQL loader -Control file with header [message #168225 is a reply to message #168178] |
Wed, 19 April 2006 06:17  |
oracle.g
Messages: 12
Registered: October 2005
|
Junior Member |
|
|
Example
-------
Control file:
Name|City|Phone
a|ABC|234
b|DEF|567
c|GHI|899
The 1st record is the header with column names. The table contains the columns
Name
City
Phone
Requirement
Need to load the data based on the header given and not based on delimiter.
In the sense I should insert it looking the header so that in future if we change the delimiter also this is not affected and based only on columns present in headers.
Thanks.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
