Re: 'substring' a LONG column
From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 22 Sep 2001 14:40:08 -0700
Message-ID: <9oj0fo0o7n_at_drn.newsguy.com>
Date: 22 Sep 2001 14:40:08 -0700
Message-ID: <9oj0fo0o7n_at_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_at_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 - 23:40:08 CEST