Skip to Main Content

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!

Remove Double Quote from string column

2795332Jun 19 2017 — edited Jun 20 2017

Oracle 11g

Could you let me know on below.

create table xxibm_notes_tbl(name varchar2(50));

insert into xxibm_notes_tbl values('"CSC"');

insert into xxibm_notes_tbl values('"IBMNOTE"');

insert into xxibm_notes_tbl values('IBMROUTE');

select * from xxibm_notes_tbl;

the above column is having double quotes, which is invisible if we look into the sql developer output, but if we copy the output to notepad then we can see double quotes.

Could you let me know how to remove the double quotes.

Thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 18 2017
Added on Jun 19 2017
7 comments
14,951 views