Re: Help with Version 7 loader, Non-Fixed length records

In article <379_at_along.dialix.oz.au>,
Alex Long <paladin_at_along.dialix.oz.au> wrote:
>
>I need to load a lot of data that has been exported from a Paradox table
>as a comma delimited file.
>
>I can't find a way to load data into Oracle 7, unless it's a fixed
>length record. All the examples that I saw seem to predicate a fixed
>length record.

The following works for me:

LOAD DATA INFILE 'mydata.dat'
INTO TABLE mytable APPEND
FIELDS TERMINATED BY ','
TRAILING NULLCOLS
(
CTYHOCN,
ID
)

-- 
Mike_at_synapse-group.com
The Synapse-Group
Providing Integrated Oracle and WWW Solutions
http://bristol.synapse-group.com/