createresult.sql

来自「本书是Oracle 9i的基础培训教程,适用于Oracle初学者和有基本了解的人」· SQL 代码 · 共 12 行

CREATE TABLE "SCOTT"."RESULT" (
    "BH"        NUMBER(10)   NOT NULL,
    "XM"        VARCHAR2(10) NOT NULL,
    "LB"        VARCHAR2(10) NOT NULL,
    "YINGYU"    NUMBER(4, 1) NOT NULL,
    "ZHENGZHI"  NUMBER(4, 1) NOT NULL,
    "ZHUANYE1"  NUMBER(4, 1) NOT NULL,
    "ZHUANYE2"  NUMBER(4, 1) NOT NULL,
    "ZHUANYE3"  NUMBER(4, 1) NOT NULL,
    "TOTALSCORE" NUMBER(5, 1) NOT NULL,
    "FLAG"      VARCHAR2(4) NOT NULL)  
TABLESPACE "USERS"