Oracle, my query is as follows:
SELECT
Anderson, d AS "id",
Anderson d_card AS idCard,
A.s ex AS "sex",
A.n ation AS "nation,"
A.o rigin_place AS "originPlace,"
A.a ge AS "age",
A.h ousehold_attribute AS "householdAttribute,"
Anderson nduction_time AS "inductionTime,"
A. irthdate AS "birthdate,"
Atul gawande raduation_time AS "graduationTime,"
Amy polumbo olitical_outlook AS "politicalOutlook,"
Atul gawande raduation_school AS "graduationSchool,"
Arjun ajor AS "major",
Arjun ax_education AS "maxEducation,"
Aleem walji orking_years AS "workingYears,"
Arjun arital_status AS "maritalStatus",
A.f ertility_status AS "fertilityStatus,"
A.h ome_address AS "homeAddress",
A. ankcard_number AS "bankcardNumber,"
A.o pening_bank AS "openingBank,"
A.e mergency_contact AS "emergencyContact,"
A.e mergency_contact_phone AS "emergencyContactPhone,"
The FROM
SYS_USER_COMMON_INFORATION a

Error: [Err] ORA - 00936: missing expression

This table predicate sentence is:
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 is NULL,"
"The birthdate DATE is NULL,"
"Graduation_time DATE is 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,
The PRIMARY KEY (" id_card ")
)
PCTFREE 10
INITRANS 1
STORAGE (
BUFFER_POOL DEFAULT
)

In TABLESPACE "USERS"
LOGGING
NOCOMPRESS
NOCACHE
;

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

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

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

CodePudding user response:

A.e mergency_contact_phone AS "emergencyContactPhone," - a comma here to remove
The FROM
SYS_USER_COMMON_INFORATION a

Table name is wrong, also built a predicate sentences NewTable, write here is that the sys...

Suggested that the predicate sentence statement of the table name, column name on both sides of the double quotes all take out, otherwise after all the operation, you must be enclosed in double quotation marks,