Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQL Loader: How to skip fields?

SQL Loader: How to skip fields?

From: Christoph Meyer <cm02_at_hdm-stuttgart.de>
Date: Wed, 19 Jan 2000 19:53:58 +0100
Message-ID: <86517s$1mbp$1@news.nikoma.de> 





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.


Received on Wed Jan 19 2000 - 12:53:58 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US