Remove Single Quote from the column value in oracle sql

Question

Guys i want the following oracle sql query to print the following value. I want to remove single quote from the column value. Let me know how to do that

select MSGID from schemaname_interface_daily_20110427 ;

Input:

X'414d51204545415837313150202020204d54a9e423d31a16'

Output:

X414d51204545415837313150202020204d54a9e423d31a16

Bibz · Accepted Answer · 2015-09-25 14:19:52Z

16

select replace (MSGID, '''', '') from schemaname_interface_daily_20110427;

Complete REPLACE function's documentation.

edited Sep 25, 2015 at 14:19

Bibz

3212 silver badges11 bronze badges

answered Apr 27, 2011 at 6:50

HAL 9000

3,9851 gold badge25 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Remove Single Quote from the column value in oracle sql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related