Re: Loading data...
From: Noel <tomekb_at_softman.pl>
Date: Sat, 29 May 2004 16:09:37 +0200
Message-ID: <c9a5ht$jaj$1_at_inews.gazeta.pl>
Date: Sat, 29 May 2004 16:09:37 +0200
Message-ID: <c9a5ht$jaj$1_at_inews.gazeta.pl>
> > 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?
Why don't help a human being?
We need to find a character which doesn't exist in data file.
Could be it:
CHR(63), CHR(96), CHR(128) - CHR(159)
FIELDS TERMINATED BY '?'
select ascii( '?') from dual;
-- 63 -- TomekBReceived on Sat May 29 2004 - 16:09:37 CEST