createtablegraduateinfo.sql

来自「Oracle 9i中文版基础培训教程」· SQL 代码 · 共 8 行

CREATE TABLE "GRADUATEUSER"."GRADUATE_INFO" ("ID" NUMBER(10) NOT 
    NULL, "NAME" VARCHAR2(10) NOT NULL, "SEX" VARCHAR2(2) NOT 
    NULL, "TYPE" VARCHAR2(10) NOT NULL, "BIRTHDAY" DATE NOT NULL,
    "CLASSNO" NUMBER(6) NOT NULL, "MAJOR" VARCHAR2(30) NOT NULL,
    "DIRECTOR" VARCHAR2(10) NOT NULL, "SOURCE" VARCHAR2(50) NOT 
    NULL, 
    CONSTRAINT "研究生学号主码" PRIMARY KEY("ID"))  
    TABLESPACE "USERS"