How does one escape special characters 2005-01-24 - By Mladen Gogala
Roger Xu wrote:
>
>How do I do it if I want to build the SQL first in a variable for a PL/SQL
statement?
>
>
>cmd:='SELECT' || l_column || 'FROM emp WHERE name LIKE '% O/'REAR' ESCAPE '/';
>
>
What are you to do with the forward slash? Slay the engine? Roger, the
RDBMS slayer? Here it is, right from the manual:
cmd:='SELECT' || l_column || 'FROM emp WHERE name LIKE '% O''REAR';
It's from the SQL reference, section called "text literals".
--
Mladen Gogala
Oracle DBA
--
http://www.freelists.org/webpage/oracle-l
|
|
