SQL Loader: How to skip fields?
From: Christoph Meyer <cm02_at_hdm-stuttgart.de>
Date: Wed, 19 Jan 2000 19:52:21 +0100
Message-ID: <86514q$1maj$1_at_news.nikoma.de>
Hi!
Date: Wed, 19 Jan 2000 19:52:21 +0100
Message-ID: <86514q$1maj$1_at_news.nikoma.de>
Hi!
[Quoted] I'm trying to load a data file with each record containing 3 fields (col_A,
col_B, col_C) using SQL*Loader.
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.Received on Wed Jan 19 2000 - 19:52:21 CET