--如以单引号重命名列,报ora-00923

SQL> select a as 'aa1',b as 'aaa2' from t_hz;

select a as 'aa1',b as 'aaa2' from t_hz

ORA-00923: FROM keyword not found where expected

---重命名我不添加单引号即正常运行
SQL> select a as aa1,b as aaa2 from t_hz;

AA1                                           AAA2
---------- ---------------------------------------
我们                                             1

SQL> select a as 列1,b as 列2 from t_hz;

列1                                             列2
---------- ---------------------------------------
我们                                             1

ITPub博客

ORA-00923: FROM keyword not found where expected

最新文章