simple_tbl.sql~

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

connect jdbc/jdbc;

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;