Is it possible to load more than one table from one control file in one sql loader statement. eq.
I got ten fields in my input file (P1 to P10). I got two tables (Table1 and Table2) where I want to load data. Values P1->P5 should go to Table1 and rest of data i.e. P6->P10 should populate in Table2. This should be done in one execution.