Re: 'substring' a LONG column
Date: Wed, 19 Sep 2001 22:44:07 +0200
Message-ID: <ju7q7.20805$1T5.248984_at_news1.oke.nextra.no>
Hi!
[Quoted] [Quoted] The LONG datatype has many constraints. Try to send the LONG column into a
PLSQL function with a parameter
VARCHAR2(max 32000 characthers I think) and use substr inside the function,
and return the 80 characthers from
the function. Such a function can be made possible to be callef from a SQL
statement.
(not tested :-)
Frank
Richelle Hutchinson <rihutchin_at_columbus.rr.com> wrote in message
news:u37q7.55438$Iq4.29737501_at_typhoon.columbus.rr.com...
> 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
>
>
Received on Wed Sep 19 2001 - 22:44:07 CEST