Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to use escape character in update statement.

user2988171Mar 18 2011 — edited Mar 18 2011
Hi All,

I'm trying to update table using following sql update statement, but everytime it's asking me for the input due to the '&' value in below sql.
UPDATE xyz_xyz
   SET NAME = 'ABC & PQR'
 WHERE ID = (SELECT ID
               FROM abc_abc
              WHERE NAME = 'C & PQR');
Please let me know how to use escape character syntax or let me know if there is any alternative solution.

Thanks,
Vishwas
This post has been answered by Saubhik on Mar 18 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 15 2011
Added on Mar 18 2011
4 comments
9,733 views