Re: how to skip columns in sqlldr

Sybrand Bakker wrote:
> 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.
>>

bottom posting is *not* global netiquette.

where there is an existing sequence of posting i will follow it, as in this case, but where there isn't i'll post wherever i like.

feel free to add me to your killfile if you think where i post is more important than what i post.

of course temp tables are unnecessary but that is all in the docs and one can read between the lines on posts like this "i don't want to rtfm - just tell me how i do it" and that is an easy way - just read the lot in and use sql to manipulate.

--
Email munged to avoid spam.  Reverse bits of it to email directly.