サンプルDB作成 - のんびりSE備忘録 @ ウィキ

create table emp
(
emp_id char(3) ,
emp_name varchar2(10),
primary key( emp_id )
)

insert into emp (emp_id,emp_name) values ('001','AAAAA');
insert into emp (emp_id,emp_name) values ('002','CCCCC');
insert into emp (emp_id,emp_name) values ('003','BBBBB');

create table dep
(
dep_id char(3),
dep_name varchar2(10),
primary key(dep_id)
)

insert into emp (emp_id,emp_name) values ('100','TOKYO');
insert into emp (emp_id,emp_name) values ('200','OSAKA');
insert into emp (emp_id,emp_name) values ('300','NAGAOYA');