Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Nevermind I got it Re: Escape character for PL/SQL
The single quote is the escape character. I wasn't getting inside my If statement.
In article <92b3ug$sj$1_at_nnrp1.deja.com>,
Scott Metzger <scottmetzger_at_my-deja.com> wrote:
> 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/
>
Sent via Deja.com
http://www.deja.com/
Received on Thu Dec 28 2000 - 16:01:37 CST