createtabledirectorinfo.sql

Oracle 9i中文版基础培训教程

CREATE TABLE "GRADUATEUSER"."DIRECTOR_INFO" ("ID" NUMBER(10) NOT 
    NULL, "NAME" VARCHAR2(10) NOT NULL, "SEX" VARCHAR2(2) NOT 
    NULL, "ZHICHENG" VARCHAR2(20) NOT NULL, "ZHIWU" VARCHAR2(20)
    NOT NULL, "MAJOR" VARCHAR2(40) NOT NULL, 
    CONSTRAINT "导师编号主码" PRIMARY KEY("ID"))  
    TABLESPACE "USERS"