Re: how to skip columns in sqlldr

[Quoted] [Quoted] On Wed, 19 Mar 2003 17:00:44 +0000, Dave <recneps.w.divad_at_elcaro.moc> wrote:

>you could read the data into a temporary table, use SQL to copy the data
>you want then drop the temporary table, perhaps something like:
>
>insert into test select p,9999,q from temp_table;
>
>where p and q are the two columns in temp_table.
>
>Dave.
>

[Quoted] All of this is *COMPLETELY* unnecessary, provided the control file has been setup correctly.

Also please observe netiquette and respnd *below* the question.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Mar 19 2003 - 19:09:07 CET