Escape character for '&' [message #19278] |
Thu, 07 March 2002 23:27 |
Raj
Messages: 411 Registered: November 1998
|
Senior Member |
|
|
Hi Have to add '&' in a String and store it in data base if I give '&Name' it asks for input, so any one cud tell me is there any escape character available for that.
Thanks.
|
|
|
|
|
Re: Escape character for '&' [message #19295 is a reply to message #19278] |
Sat, 09 March 2002 16:18 |
Sudhakar Atmakuru
Messages: 58 Registered: May 2001
|
Member |
|
|
Turn the ESCAPE on by SET and precede the ampersent with a backslat '' in your SQL statement. That is it. It should work. For example, it would look like
SET ESCAPE ON
SELECT '&NAME' FROM DUAL;
It outputs a column with &NAME value.
Good luck.
|
|
|