I am very new to SQL *Loader. We are starting to use SQL *Loader to load the data in to a table.
If I want to populate a column in the table concatinating with two other columns together..
Is it possible to do this???
I am posting my code.
INTO TABLE LOAD
(A POSITION(05:19) CHAR,
B POSITION(189:197) CHAR,
C EXPRESSION "TRUNC(Last_day(add_months(sysdate, -1)))",
D EXPRESSION "A||C" 'populate D column woth A AND C)
Any help is appriciated.