-
Hello,
I have a table say TAB1. It has one field
f1 VARCHAR2(10)
I want to do something like
insert into TAB1 values('a&b');
where that '&' needs to go in as a string.
When I run thisd statement in SQL*Plus it is asking for the value of 'b'.
I want the '&' to be treated as a normal string instead of a special character. How do I do this.
I tried with
insert into TAB1 values('a\&b');
But it did not work......
Please help
Thank you
-
Hi!
Try
SQL> set escape '\'
SQL> insert into TAB1 values('a\&b');
It will work
There Nothing You cannot Do, The problem is HOW.
-
Hi Sudip,
Yes...it did work !!!!
Thanks a lot for your help.
-
Special Char
Mr. Ghosh,
It is ok. u can keep on posting such kind of uestions. it hekps starters like us ;-)
--------------------------
The Time has come ....
-
Re: Special Char
Originally posted by vijay8282
Mr. Ghosh,
It is ok. u can keep on posting such kind of uestions. it hekps starters like us ;-)
We all have something or the other to learn here.
There Nothing You cannot Do, The problem is HOW.
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
|