Re: Escape character for PL/SQL

From: Walter Dorninger <walter.dorninger_at_aon.at>
Date: Wed, 27 Dec 2000 10:51:02 +0100
Message-ID: <92ce48$1dko$1@wrath.news.nacamar.de>

Hi Scott,

just use three qotes '''

Hope this helps,
Walter

"Scott Metzger" <scottmetzger_at_my-deja.com> wrote in message news:92b3ug$sj$1_at_nnrp1.deja.com...
> Hi,
>
> What is the escape character for PL/SQL?
>
> I need to assign the value of a Varchar2 variable in a stored procedure.
> The text includes single quotes '. How do I make the assignment?
>
> I have tried:
> SelectClause := 'VALUES (''0'',''U'',''84'')';
> I have also tried using / and \.
>
> Thanks,
> Scott
>
>
>
> Sent via Deja.com
> http://www.deja.com/
>
Received on Wed Dec 27 2000 - 03:51:02 CST