在 sql server 下
语句为
select 100 as a-b 的语句
只要改成
select 100 as [a-b]
就可以正常运行,
但是在 oracle 下
select 100 as a-b from dual 如何更改才能正常运行?
select 100 as [a-b] from dual 这个不行。
------解决方案--------------------
select 100 as "a-b" from dual;
------解决方案--------------------
- SQL code
select 100 as "a-b" from dual;