[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>


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-4864
Received on Sat Jul 09 1994 - 19:34:29 CEST

Original text of this message