Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SqlLoader
- Thread starter IMAUser
- Start date
If you are trying to combine Column 1 and Column 2, and insert the combination into the table, then use SQL*LOADER column EXPRESSION.
If you don't want to load Column 1 and Column 2 to the table by themselves, define them both as BOUNDFILLER.
This will allow you to use the data in the input file fields in expressions without having to define columns in the target table.
Hope this helps,
Charles
If you don't want to load Column 1 and Column 2 to the table by themselves, define them both as BOUNDFILLER.
This will allow you to use the data in the input file fields in expressions without having to define columns in the target table.
Hope this helps,
Charles
- Status