SQLLDR : Terminators
From: Geoffrey Dufour <g.dufour_at_swing.be>
Date: Wed, 18 Jul 2001 10:00:21 +0200
Message-ID: <3b554161$0$4566$ba620e4c_at_news.skynet.be>
Date: Wed, 18 Jul 2001 10:00:21 +0200
Message-ID: <3b554161$0$4566$ba620e4c_at_news.skynet.be>
Hi,
It is said in the SQL*LOADER Control File Reference Documentation that
Termminators are strings not limited to a single character.
How can I define multiple characters Terminator Strings ?
ex : id INTEGER EXTERNAL TERMINATED by 'ABC'
It does not work.
Error =
Expecting single char, found "ABC".
id INTEGER EXTERNAL TERMINATED BY 'ABC',
Regards.