-
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 &?
There Nothing You cannot Do, The problem is HOW.
-
Hi
what version are you on ? i just tested it on 8.1.7 and no problems and no need for escape sequence for &!
-
There Nothing You cannot Do, The problem is HOW.
-
I tested : got the same problem as yours ... the workaround is :
insert into trial(name)
values ('abc ' || chr(38) || ' co');
-
There Nothing You cannot Do, The problem is HOW.
-
set Options-ESCAPE= \ in SQLPLUS
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
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
-
Re: set Options-ESCAPE= \ in SQLPLUS
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
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|