Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 'substring' a LONG column
In article <u37q7.55438$Iq4.29737501_at_typhoon.columbus.rr.com>, "Richelle says...
>
>Does anyone know how to 'substring' a LONG field? We need to obtain the
>first 80 characters and the substring function won't work. Changing this
>column to a LOB datatype on the database is not an option at this time.
>
>Thanks in advance.
>
>-Richelle Hutchinson
>
>
see
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:55212348054
for various methods.
-- Thomas Kyte (tkyte@us.oracle.com) http://asktom.oracle.com/ Expert one on one Oracle, programming techniques and solutions for Oracle. http://www.amazon.com/exec/obidos/ASIN/1861004826/ Opinions are mine and do not necessarily reflect those of Oracle CorpReceived on Sat Sep 22 2001 - 16:40:08 CDT