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: How to get SQL Loader to skip a column in a CSV file?

Re: How to get SQL Loader to skip a column in a CSV file?

From: Tim Shute <tshute_at_nisoft.co.uk>
Date: Tue, 3 Aug 1999 11:32:21 +0100
Message-ID: <049F56710FD6D211B08D006097A4426B0DEFBF@orion>


CSV?
Customers Should Vanish?
Complete Support Vacuum?
Can't See Visibly?

Comma Separated Variable, as far as I know. In other words a text file containing data with the fields separated by commas and with each field of variable length.

HTH --
--
Tim Shute
Software Engineering Manager

NiSoft (UK) Limited
Unit 8, 31 Ballynahinch Road, Carryduff, BELFAST BT8 8EH Internet: www.nisoft.co.uk

Kenneth C Stahl <BluesSax_at_Unforgettable.com> wrote in message news:37A5851B.48FE8826_at_Unforgettable.com...
> Micko wrote:
>
> > I want to get SQL loader to skip a column in a CSV file I'm loading. At
the
> > moment I am using a workaround based on the POSITION (*+n) because I can
> > currently ensure that the field I want to skip always has the same
width;
> > this will not be the case in production. Have gone through the manual
but no
> > dice - help!
>
> What are these CSV files that everyone keeps mentioning?
Received on Tue Aug 03 1999 - 05:32:21 CDT

Original text of this message

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