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 reterieve records with "&QUOT"

va44725815Feb 19 2007 — edited Feb 19 2007
Hi,
I am trying to reterieve records where "&QUOT" exists in data, and replace this with single quote. i have used the following queries but it does not work.

select idx,source,OFF_NAME,OFF_NAME_FORM, WEBSITE_FORM
from TT
where OFF_name_FORM like '%' || chr(38) || 'QUOT'

select idx,source,OFF_NAME,OFF_NAME_FORM, WEBSITE_FORM
from TT
where OFF_name_FORM like '%' || '&' || 'QUOT'

can anybody let me know how to get the required output.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 19 2007
Added on Feb 19 2007
6 comments
933 views