Re: How to process data within SQL*Loader?

you can use all of the sql*plus commands within your sql*loader script....just be sure to enclose the statements in single quotes and precede the column name with a colon....ie. reformatting a date for example:

column my_date is a column with date in format YYMMDD so

into table mytable

columns (my_date       position 1:6 'to_date(:my_date,'YYMMDD'),
                another_col position 7:15,
                yet_anthrun position 16:25)

Jack Richter
Jack Richter
Senior Consultant-Oracle
Eagles International, Inc Received on Fri Jun 23 1995 - 00:00:00 CEST