SQL> create table t_a(a int);

Table created

SQL> select a as 成功/失败 from t_a;--因别名包含/引发错误

select a as 成功/失败 from t_a

ORA-00923: FROM keyword not found where expected

SQL> select a as '成功/失败' from t_a;--对别名添加单引号失败

select a as '成功/失败' from t_a

ORA-00923: FROM keyword not found where expected

SQL> select a as "成功/失败" from t_a;--添加双引号即可

成功/失败
---------------------------------------

小结:1,最好在列别名不用要汉字,兼容太差

2,不要在列别名中使用特殊字符如:/

ITPub博客

sql列别名引发ORA-00923: FROM keyword not found where expected

最新文章