日期:2014-05-17 浏览次数:20899 次
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;