Question: ORACLE sql result with single quotation - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Question: ORACLE sql result with single quotation

Question: ORACLE sql result with single quotation# Database - 数据库

y*a2009-06-29 07:06

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.

B*g2009-06-29 07:06

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.