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!

Replace '&' with 'AND'

515762Aug 31 2006 — edited Aug 31 2006

Hi All

I am creating a XML file with a procedure.
It works fine but when i want to open it gives the error bcos of '&'
For that i want to use the escape(is it right)
like for description field how can i query to replace '&' with 'AND'
can anyone help me in quering it as well
Please let me know
Thanks
Mandar

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 28 2006

Added on Aug 31 2006

2 comments

561 views