createresult.sql

本书是Oracle 9i的基础培训教程,适用于Oracle初学者和有基本了解的人员.内部有VB代码

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"