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 -> Re: skip field in delimited file for sql*loader

Re: skip field in delimited file for sql*loader

From: Thomas Kyte <tkyte_at_oracle.com>
Date: 22 Jan 2003 11:39:28 -0800
Message-ID: <b0ms1g02jbu@drn.newsguy.com>


In article <8882aa3c.0301221025.1cffe1a0_at_posting.google.com>, andyho99_at_yahoo.com says...
>
>Hi,
>
>Is there a way to skip a field in a delimited file? In a fixed format
>file, I can specify the position using POSITION keyword. The goal is
>not to change input file if possible. Thanks.

http://asktom.oracle.com/~tkyte/SkipCols/index.html

--
Thomas Kyte (tkyte@oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp 
Received on Wed Jan 22 2003 - 13:39:28 CST

Original text of this message

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