Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 'substring' a LONG column

Re: 'substring' a LONG column

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 22 Sep 2001 14:40:08 -0700
Message-ID: <9oj0fo0o7n@drn.newsguy.com>


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 Corp 
Received on Sat Sep 22 2001 - 16:40:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US