Re: Passing Quotes to procedures in PL/SQL

From: Terry Dykstra [TeamPS] <no_spam_tdykstra_at_cfol.ab.ca>
Date: 17 Apr 98 19:20:01 GMT
Message-ID: <01bd6a36$072845e0$3301020a@tdykstra>

You can define an escape character: WHERE x LIKE y [ESCAPE 'z']. See the Oracle7 Server SQL reference, chapter 3 : comparison operators.

--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.

Poorna Prakash <poorna_prakash_at_sabre.com> wrote in article <35367CDB.8E4612C_at_hotmail.com>...
> Folks.
>
> I was reading a message about how to pass parameters with single
> quotes to procedures in PL/SQL. Could you please repost with your
> hints please.
>
> Thanks
>
> -Peter
>
>
>
Received on Fri Apr 17 1998 - 14:20:01 CDT