createdirector.sql

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

CREATE TABLE "SCOTT"."DIRECTOR" (
         "DIRECTOR_ID"    NUMBER(6)        NOT NULL,
         "NAME"           VARCHAR2(10)     NOT NULL,
         "ZHICHENG"       VARCHAR2(20)     NOT NULL,
         "ZHIWU"          VARCHAR2(20)     NOT NULL, 
    CONSTRAINT "导师编号主码" PRIMARY KEY("DIRECTOR_ID") 
    USING INDEX  
    TABLESPACE "USERS")  
    TABLESPACE "USERS"