Hi!
Whenever I am trying to fire the following insert it is prompting for enter value of co.
insert into trial (name) values ('abc & co');
what is escape sequence for &?
Printable View
Hi!
Whenever I am trying to fire the following insert it is prompting for enter value of co.
insert into trial (name) values ('abc & co');
what is escape sequence for &?
Hi
what version are you on ? i just tested it on 8.1.7 and no problems and no need for escape sequence for &!
I am using 8.1.6.
I tested : got the same problem as yours ... the workaround is :
insert into trial(name)
values ('abc ' || chr(38) || ' co');
YEah it worked Thanx
Hi, 16th May 2001 14:38 hrs *******
1)Type as escape on
2)Go to menu in SQL Plus OPTIONS==>ENVIRONMENT==>ESCAPE==>VALUE(set it as / )
3)Come to SQL PLUS screen and now insert a value as
SQL> insert intovalues('abc \& co');
Well finished.
Cheers
Padmam
Hi, 16th May 2001 15:09 hrs *******
you can also mark it as
SET ESCAPE ON
SET ESCAPE "\"
followed by insert in to the table.
in SQL PLUS
cheers
Padmam