Skip to Main Content
Forums

Java Database Connectivity (JDBC)

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!

replacing ' with ' in pl/sql select statement

843859Aug 11 2006 — edited Aug 14 2006
Hi,

I need to write an sql statement where returned data containg single quote ' should be replaced by &apos

example

returned data : Perl's
new data : Perl's

I tried to use replace function of sql, but didnt succedd.

select replace(first_name,'/'',''') from tablename where first_name like '%P%'
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 11 2006
Added on Aug 11 2006
#java-database-connectivity-jdbc
2 comments
595 views