sql loader
From: Hoang-Vu PHUNG <hoang-vu_at_freesurf.ch>
Date: Fri, 10 Dec 1999 11:04:30 +0100
Message-ID: <82qj7j$j07$1_at_news1.sunrise.ch>
Hi,
Date: Fri, 10 Dec 1999 11:04:30 +0100
Message-ID: <82qj7j$j07$1_at_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 - 11:04:30 CET