test7_oracle.sql

来自「hibernate的经典练习」· SQL 代码 · 共 13 行

drop table  USERS;
create table USERS (
   ID varchar(15) not null ,
   NAME varchar(15) not null unique,
   NUMBER1 NUMBER,
   primary key (ID)
);
insert into USERS(ID,NAME,NUMBER1) values('10001','Tom',21);
insert into USERS(ID,NAME,NUMBER1) values('10002','Mike',24);
insert into USERS(ID,NAME,NUMBER1) values('10003','Jack',30);
insert into USERS(ID,NAME,NUMBER1) values('10004','Linda',25);
commit;