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!

Find and Replace String in a Column

909328Feb 1 2012 — edited Feb 1 2012

Hi,

In the table data got stored with " " (Double Quotes) I need to remove these double quotes Please suggest me how to remove

Select address from TECH_SOURCING_EMPLOYEE_DETAILS

"No 12/32" ---> data been saved in this format in the table. I need to remove the double quotes

Thanks
Sudhir

This post has been answered by Frank Kulash on Feb 1 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 29 2012

Added on Feb 1 2012

3 comments

4,305 views