Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Nevermind I got it Re: Escape character for PL/SQL

Nevermind I got it Re: Escape character for PL/SQL

From: Scott Metzger <scottmetzger_at_my-deja.com>
Date: Thu, 28 Dec 2000 22:01:37 GMT
Message-ID: <92gd7u$1jc$1@nnrp1.deja.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US