sql - Oracle 合并列给出错误

Question

我在 oracle 中有 2 列，我正在合并如下

select SURVEY_AREA_7_12 || ' ' || HISSA_NO_7_12 
from XXCUS.XXACL_PN_FARMING_MST

工作正常。但是当我将自己的名字添加到如下列时

select SURVEY_AREA_7_12 || ' ' || HISSA_NO_7_12 as 712_Column 
from XXCUS.XXACL_PN_FARMING_MST

它给出的错误是

ORA-00923: FROM keyword not found where expected

Answer 1

问题是您的别名在第一个位置有一个数字；您可以引用它或更改别名:

Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL> select 'a' as 1ABC from dual;
select 'a' as 1ABC from dual
              *
ERROR at line 1:
ORA-00923: FROM keyword not found where expected


SQL> select 'a' as "1ABC" from dual;

1ABC
----
a

与第一个位置不同的数字没有问题:

SQL> select 'a' as ABC1 from dual;

ABC1
----
a