Re: How to search for pattern on LONG columns

From: Shajith, T V <shajith_thaze_at_bose.com>
Date: 1998/01/15
Message-ID: <01bd21de$2b6d94a0$78b3448b@jmartintemp.bose.com>#1/1

You cannot do it in SQL.
But in PL/SQL declare a variable of varcahr2 and assign the long colum to the variable and you can process the data.

Thanks,
Shajith

Poorna Prakash <poorna_prakash_at_sabre.com> wrote in article <34BE3B2D.25BA_at_sabre.com>...
> It appears impossible to me, to search for a pattern on a column whose
> datatype happens to be LONG. If someone could help me, suggest a way by
> which, I could convert LONG columns to VARCHAR2, or any other method by
> which you could approach this problem, I would greatly appreciate.
>
> Thanks much.
>
> Prakash
>
Received on Thu Jan 15 1998 - 00:00:00 CST