CODEWITHSUNDEEP
sqloracle-database
Dead Programmer
Dead Programmer

Reputation: 12575

Remove Single Quote from the column value in oracle sql

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

Upvotes: 6

Views: 35731

Answers (1)

HAL 9000
HAL 9000

Reputation: 3985

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

Complete REPLACE function's documentation.

Upvotes: 16

Related Questions