日期:2014-05-17 浏览次数:20902 次
CREATE TABLE T155
(
    GID NUMBER(2),
    F1 NUMBER(4),
    F2 NUMBER(4)
);
INSERT INTO T155 VALUES(1, 10, 0);
INSERT INTO T155 VALUES(2, 15, 1);
INSERT INTO T155 VALUES(3, 20, 0);
CREATE TABLE T156
(
    GID NUMBER(2),
    F3 NUMBER(4),
    F4 NUMBER(4)
);
INSERT INTO T156 VALUES(1, 100, 101);
INSERT INTO T156 VALUES(2, 200, 201);
INSERT INTO T156 VALUES(3, 300, 301);
CREATE TABLE T157
(
    GID NUMBER(2),
    F5 NUMBER(4)   
);
INSERT INTO T157 VALUES(1, 1000);
INSERT INTO T157 VALUES(2, 2000);
INSERT INTO T157 VALUES(3, 3000);
COMMIT;