오라클 sql developer 정보 날아갈까봐 기록하는
sqld 공부용 사원정보 오라클
더미 파일
create table emp (
id number(2) primary key,
name varchar2(20),
dept_code number(4),
salary number(10),
foreign key(dept_code) references dept(dept_code)
);
create table dept (
dept_code number(4) primary key,
dept_name varchar2(20)
);
insert into dept values(1000, '기획팀');
insert into dept values(2000, '경영지원팀');
insert into dept values(3000, '교육지원팀');
insert into emp values(1, '문희', 2000, 180);
insert into emp values(2, '김희', 1000, 300);
insert into emp values(3, '최희', 3000, 500);
insert into emp values(4, '원필', 2000, 255);
insert into emp values(5, '성진', 1000, 330);
insert into emp values(6, '영케이', 3000, 280);
insert into emp values(7, '도운', 2000, 185);
insert into emp values(8, '홍길동', 1000, 333);
insert into emp values(9, '을지문덕', 3000, 650);
insert into emp values(10, '김아무개', 2000, 220);