Re: Loading data...

Richard S. Crawford wrote:

> I am having problems loading data into my Oracle 9i database. I've
> tried using SQL Loader but it looks like all of the possible field
> delimiters that could be used -- !, |, ~, ^, etc. -- are already in use
> in some text field or another in my database.
>
> Am I SOL with this?

If so ... how does a human being tell which ones are delmiters and which are not?

Blow the entire record, unparsed, into a single VARCHAR2 column and then write a proc to distribute it from there.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)