Re: SQL Loader: How to skip fields?

A copy of this was sent to "Christoph Meyer" <cm02_at_hdm-stuttgart.de [nospam]> (if that email address didn't require changing) On Wed, 19 Jan 2000 19:53:58 +0100, you wrote:

>Hi!
>
>I'm trying to load a data file with each records containing 3 fields (col_A,
>col_B, col_C).
>The table in the database, however, contains 2 fields only (field1, field2)
>What's the syntax for the loader script to load:
>col_A into field1,
>col_C in field2 and
>skip col_B?
>
>Any suggestions? Thanks in advance.
>Christoph Meyer
>
>---
>Please remove [nospam] before replying.
>

see http://osi.oracle.com/~tkyte/SkipCols/index.html

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Jan 19 2000 - 13:24:26 CST