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