| Escape character in oracle.. [message #54862] |
Wed, 11 December 2002 00:16  |
sai
Messages: 27
Registered: October 2001
|
Junior Member |
|
|
hello all,
i got hooked in a strange problem,
create table test(eno number,link varchar2(1000));
Table created.
insert into test values(100,'http://www.ram.com/&link=filename.asp');
if i execute the above statement, it will ask me to enter the value for link as there is an ampersand before that..which i dont want it to ask me...as it was a hardcoated statment.
please help me with the correct statement.
sai
|
|
|
|
| Re: Escape character in oracle.. [message #54865 is a reply to message #54862] |
Wed, 11 December 2002 00:36  |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
You can do one of the following in SQL*Plus:This will stop SQL*Plus from scanning for user input. You could redefine the scan character to any other character you want.This will enable the escape character. The default is '', but you can define another character. You simply place the escape character before any ampersand you want to escape.
see also here.
MHE
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
