Re: Searching for text in a Long
From: Angelito Dizon <adizon_at_mail.us.net>
Date: 1996/12/02
Message-ID: <73740.adizon_at_mail.us.net>#1/1
Date: 1996/12/02
Message-ID: <73740.adizon_at_mail.us.net>#1/1
On 1 Dec 1996 03:30:34 GMT,
N Prabhakar <prabhs_at_po.pacific.net.sg> wrote:
>Write a PL/SQL block. Fetch the value of long column into a VARCHAR2
>variable of length 2000. Then use INSTR to find out whether your
>search string is in the fetched variable.
Thanks for your input. The above would work if the search string is within the first 2000 chars of the LONG. What can I do if it occurs beyond the 2000th position?
Lito
Lito Dizon
adizon_at_us.net
Received on Mon Dec 02 1996 - 00:00:00 CET