sql loader

From: Hoang-Vu PHUNG <hoang-vu_at_freesurf.ch>
Date: Fri, 10 Dec 1999 11:27:47 +0100
Message-ID: <82qkie$1dd$1@news1.sunrise.ch>

Hi,

Maybe somebody can explain me why my control file doesn't work as I like:

Here is its content:

OPTION (ERRORS = 999)
LOAD DATA
INFILE *
BADFILE 'bad.doc'
INTO TABLE SQLLDR_TEST -- just a table with columns val1, val2, val3 of varchar2
TRUNCATE
FIELDS TERMINATED BY '!' OPTIONALLY ENCLOSED BY ']' AND '[' (VAL1, VAL2, VAL3)
BEGINDATA
-- 1th try

]A[!]B[!]C[ -- Give NULL to VAL1 the others are correct
-- 2nd try

]AA[!]B[!]C[ -- Give [ to VAL1
-- 3rd try

]AAA!]B[!]C[ -- Give A to VAL1
-- 4th try

]]]AAA!]B[!]C[ -- Give AAA to VAL1 so correct . WHY ???

Thanks for any help.
Hoang-Vu PHUNG Received on Fri Dec 10 1999 - 04:27:47 CST