SQL*Loader question
From: <consulet_at_my-deja.com>
Date: Fri, 20 Oct 2000 20:57:53 GMT
Message-ID: <8sqbkd$qkh$1_at_nnrp1.deja.com>
Date: Fri, 20 Oct 2000 20:57:53 GMT
Message-ID: <8sqbkd$qkh$1_at_nnrp1.deja.com>
I have a source data file with delimiter CHR(1) and record terminator CHR(2). Can I use the FIELDS TERMINATED BY 'CHR(1)' as indicated following:
LOAD DATA
INFILE 'text.txt'
REPLACE
INTO TABLE Test
FIELDS TERMINATED BY 'CHR(1)'
( .....
.....
)
Also, will I have a problem with the record terminator CHR(2)? Since SQL*Loader use new line (\n) as end of record sign.
Kevin
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Oct 20 2000 - 22:57:53 CEST