Hi,
select translate(string,',"''','XYZ') from Dual
Only for single quote you need the escape character (another single
quote).The above query changes the comma character to X , Double quote
character to Y and single quote character to Z.
Regards,
Shankar
This e-mail and any files transmitted with it are for the sole use of the intended
recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message.
Any unauthorised review, use, disclosure, dissemination, forwarding, printing or
copying of this email or any action taken in reliance on this e-mail is strictly
prohibited and may be unlawful.
Visit us at http://www.cognizant.com
