simple_tbl.sql

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

drop table Simple_Tbl;


create table Simple_Tbl  (
   id                   NUMBER(9)                        not null,
   name                 VARCHAR2(30)
);

insert into Simple_Tbl(id, name) values (1, 'kevin');
insert into Simple_Tbl(id, name) values (2, 'george');
insert into Simple_Tbl(id, name) values (3, 'larry');
insert into Simple_Tbl(id, name) values (4, 'renee');

commit;