|
Re: How to replace '&' with '& ' ? [message #29749 is a reply to message #29747] |
Fri, 19 March 2004 14:12   |
William Robertson
Messages: 1643 Registered: August 2003 Location: London, UK
|
Senior Member |
|
|
'&' only has a special meaning within SQL*Plus, where it is the default DEFINE character. Use SET DEFINE to choose a different character, or switch it off altogether. '&' has no special meaning in PL/SQL.
SQL> set def off
SQL> SELECT REPLACE('Some text containing &','&','&') FROM dual;
REPLACE('SOMETEXTCONTAININ
--------------------------
Some text containing &
1 row selected.
|
|
|
|