srt_tbl.sql

来自「开源中间件 导入Hibernate相关的包进该项目： 选中项目名称后单击鼠标」· SQL 代码 · 共 18 行

drop table srt_tbl;

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

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

commit;