oid.sql~

来自「这是一本描述JDBC数据库的书籍」· SQL~ 代码 · 共 18 行

connect jdbc/jdbc;

drop table oid_tbl;

create table oid_tbl (nextval number(15) not null, type   number(10) not null);

insert into oid_tbl (nextval, type) values (1, 1);
insert into oid_tbl (nextval, type) values (1, 11);
insert into oid_tbl (nextval, type) values (1, 12);
insert into oid_tbl (nextval, type) values (1, 111);
insert into oid_tbl (nextval, type) values (1, 112);
insert into oid_tbl (nextval, type) values (1, 121);
insert into oid_tbl (nextval, type) values (1, 122);
insert into oid_tbl (nextval, type) values (1, 2);
insert into oid_tbl (nextval, type) values (1, 21);
insert into oid_tbl (nextval, type) values (1, 22);

commit;