Redian新闻
>
Question: ORACLE sql result with single quotation
avatar
Question: ORACLE sql result with single quotation# Database - 数据库
y*a
1
select employee.name AS name from employee
The output is TOM but I need 'TOM' with the two single quotes. I have tried
to add the three single quotation here but it didn't work out.
avatar
B*g
2
3个不行试4个
select ''''||employee.name||'''' AS name from employee

tried

【在 y***a 的大作中提到】
: select employee.name AS name from employee
: The output is TOM but I need 'TOM' with the two single quotes. I have tried
: to add the three single quotation here but it didn't work out.

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。