Oracle ORA-00936: missing expression 错误

[qq_30104843]

Oracle中，我的查询语句如下：
SELECT
a.id AS "id",
a.id_card AS "idCard",
a.sex AS "sex",
a.nation AS "nation",
a.origin_place AS "originPlace",
a.age AS "age",
a.household_attribute AS "householdAttribute",
a.induction_time AS "inductionTime",
a.birthdate AS "birthdate",
a.graduation_time AS "graduationTime",
a.political_outlook AS "politicalOutlook",
a.graduation_school AS "graduationSchool",
a.major AS "major",
a.max_education AS "maxEducation",
a.working_years AS "workingYears",
a.marital_status AS "maritalStatus",
a.fertility_status AS "fertilityStatus",
a.home_address AS "homeAddress",
a.bankcard_number AS "bankcardNumber",
a.opening_bank AS "openingBank",
a.emergency_contact AS "emergencyContact",
a.emergency_contact_phone AS "emergencyContactPhone",
FROM
SYS_USER_COMMON_INFORATION a

报错：[Err] ORA-00936: missing expression

这张的表建表语句是：
CREATE TABLE "USUM"."NewTable" (
"id" VARCHAR2(255 BYTE) NOT NULL ,
"id_card" NUMBER(20) NOT NULL ,
"sex" VARCHAR2(255 BYTE) NULL ,
"nation" VARCHAR2(255 BYTE) NULL ,
"origin_place" VARCHAR2(255 BYTE) NULL ,
"age" NUMBER(20) NULL ,
"household_attribute" VARCHAR2(255 BYTE) NULL ,
"induction_time" DATE NULL ,
"birthdate" DATE NULL ,
"graduation_time" DATE NULL ,
"political_outlook" VARCHAR2(255 BYTE) NULL ,
"graduation_school" VARCHAR2(255 BYTE) NULL ,
"major" VARCHAR2(255 BYTE) NULL ,
"max_education" VARCHAR2(255 BYTE) NULL ,
"working_years" VARCHAR2(255 BYTE) NULL ,
"marital_status" VARCHAR2(255 BYTE) NULL ,
"fertility_status" VARCHAR2(255 BYTE) NULL ,
"home_address" VARCHAR2(255 BYTE) NULL ,
"bankcard_number" NUMBER(20) NULL ,
"opening_bank" VARCHAR2(255 BYTE) NULL ,
"emergency_contact" VARCHAR2(255 BYTE) NULL ,
"emergency_contact_phone" NUMBER(20) NULL ,
PRIMARY KEY ("id_card")
)
PCTFREE 10
INITRANS 1
STORAGE (
BUFFER_POOL DEFAULT
)

TABLESPACE "USERS"
LOGGING
NOCOMPRESS
NOCACHE
;

ALTER TABLE "USUM"."NewTable" ADD FOREIGN KEY ("id") REFERENCES "USUM"."SYS_USER" ("ID") ON DELETE CASCADE;

ALTER TABLE "USUM"."NewTable" ADD CHECK ("id" IS NOT NULL);

ALTER TABLE "USUM"."NewTable" ADD CHECK ("id_card" IS NOT NULL);

[卖水果的net]

a.emergency_contact_phone AS "emergencyContactPhone", -- 这里的逗号要去掉 FROM SYS_USER_COMMON_INFORATION a 表名称也不对，建表语句中是 NewTable，这里写的是 sys… 建议把建表语句语句中的 表名称、列名称两侧的双引号全去掉，不然以后所有的操作，你必须加上双引号。