Re: search for 's string in database

From: <tandym_at_hotmail.com>
Date: Fri, 27 Oct 2000 15:14:24 GMT
Message-ID: <8tc648$ndp$1@nnrp1.deja.com>

I believe you will need to use a pl/sql block to do this, perhaps using a variable to supply the table name and then looping your select statement(s) with a cursor.

sonya

In article <8t8uvq$at$1_at_kermit.esat.net>, "pk" <paul.kavanagh_at_exceptis.com> wrote:
> Hi,
> I'd be grateful if anyone can help me write a sql to search
> for the following in a database ..... 's
>
> eg
> 'the cardholder's amount'
>
> I want the sql to reaturn where this appears in the database
> Can this be done through sql or does it have to be a pl/sql block ?
>
> thanks in advance for your help
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 27 2000 - 10:14:24 CDT