Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Escape character for PL/SQL
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 Tue Dec 26 2000 - 15:52:17 CST