Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: multiple infiles into a same table/record
> cant SQL Loader do this directly? coz im trying to load data from 2
> files into 1 staging table and then read data from the staging table,
> do some more validations and put it into another table.Any idea if SQL
> Loader can do this?
Look at the APPEND clause in control file. Trigger on stagging table can do rest of job.
-- TomekBReceived on Fri May 28 2004 - 03:06:45 CDT