[Q]: SQL*Loader "TERMINTE BY" clause
From: Neil Greene <neil_at_kynug.org>
Date: Sat, 9 Jul 1994 17:34:29 GMT
Message-ID: <1994Jul9.173429.8584_at_KYnug.org>
Date: Sat, 9 Jul 1994 17:34:29 GMT
Message-ID: <1994Jul9.173429.8584_at_KYnug.org>
Is there a way to have a variable length character field, terminated until the occurance of a newline.
Something like this is what I am looking for:
----> TEXTFIELD POSITION(*+2) TERMINATED BY NEWLINE
I don't know how to do this other then having the file contain some
designated TERMIANTE BY character. I am guessing a backslash will do the
trick "\". But I was wondering if SQL*Loader had anything that could do
the trick?
-- Neil Greene benchMark Developments, Inc. [NeXT VAR] 2040 Regency Road, Suite C Lexington, KY 40503 Phone: 606-231-6599 / Fax: 606-254-4864Received on Sat Jul 09 1994 - 19:34:29 CEST