Insert &s

[sudip]

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 &?

[shawish_sababa]

Hi

what version are you on ? i just tested it on 8.1.7 and no problems and no need for escape sequence for &!

[sudip]

I am using 8.1.6.

[pipo]

I tested : got the same problem as yours ... the workaround is :

insert into trial(name)
values ('abc ' || chr(38) || ' co');

[sudip]

YEah it worked Thanx

[padmam]

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 into values('abc \& co');

Well finished.

Cheers

Padmam

[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