SQL 从oracle sql中的列值中删除单引号
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/5800448/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
提示：将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间：2020-09-01 10:19:33 来源:igfitidea点击:
Remove Single Quote from the column value in oracle sql
提问by Dead Programmer
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
伙计们，我希望以下 oracle sql 查询打印以下值。我想从列值中删除单引号。让我知道怎么做
select MSGID from schemaname_interface_daily_20110427 ;
Input:
输入：
X'414d51204545415837313150202020204d54a9e423d31a16'
Output:
输出：
X414d51204545415837313150202020204d54a9e423d31a16
回答by HAL 9000
select replace (MSGID, '''', '') from schemaname_interface_daily_20110427;
