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);
uj5u.com熱心網友回復：
a.emergency_contact_phone AS "emergencyContactPhone", -- 這里的逗號要去掉FROM
SYS_USER_COMMON_INFORATION a
表名稱也不對，建表陳述句中是 NewTable，這里寫的是 sys…
建議把建表陳述句陳述句中的 表名稱、列名稱兩側的雙引號全去掉，不然以后所有的操作，你必須加上雙引號。
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/85200.html
標籤：開發
上一篇：查詢本身有問題、未正確設定 "ResultSet" 屬性、未正確設定引數或未正確建立連接。
下一篇：oracle 無效SQL陳述句