?? createstudent.sql
字號:
CREATE TABLE "SCOTT"."STUDENT" (
"STUDENT_ID" NUMBER(8) NOT NULL,
"NAME" VARCHAR2(10) NOT NULL,
"PROFESSIONAL" VARCHAR2(10) NOT NULL,
"BIRTHDAY" DATE NOT NULL,
"DIRECTOR_ID" NUMBER(6) NOT NULL,
CONSTRAINT "研究生編號主碼" PRIMARY KEY("STUDENT_ID")
USING INDEX
TABLESPACE "USERS",
CONSTRAINT "導師編號外碼" FOREIGN KEY("DIRECTOR_ID")
REFERENCES "SCOTT"."DIRECTOR"("DIRECTOR_ID"))
TABLESPACE "USERS"
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -