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!

eliminate double quotes which are invisible using sql query

AmivaJan 4 2018 — edited Jan 4 2018

Hi,

I am trying to compare two table with the column address. one table column address having double quotes which is not visible. i tried replace command but still it is showing double quotes when i copy to notepad. other table is not having double quotes for the address.

How to eliminate double quotes. please help me to write a query or solution to eliminate these quotes in table1

address column for table1 is

"309 KENT STREET

AUSTRALIA‎"

address table 2 is showing as

309 KENT STREET AUSTRALIA‎

This post has been answered by Frank Kulash on Jan 4 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 1 2018

Added on Jan 4 2018

10 comments

4,232 views