Skip to Main Content
Forums

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 replace double quotes with a single quote in a string ?

395422Oct 24 2008 — edited Oct 24 2008
Hi All:
Can some one tell me how to replace double Quote (") in a string with a single quote (') ? I tried to use REPLACE function, but I couldn;t get it worked.

My example is SELECT REPLACE('STN. "A"', '"', ''') FROM Dual --This one throws an error


Thanks,
Dima.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 21 2008
Added on Oct 24 2008
5 comments
14,299 views