[Oracle] 연습용 테이블 dept, emp
create table dept( deptno number, dname varchar2(14), loc varchar2(13), constraint pk_dept primary key (deptno) ); create table emp( empno number, ename varchar2(10), job varchar2(9), mgr number(4,0), hiredate date, sal number(7,2), comm number(7,2), deptno number, constraint pk_emp primary key (empno), constraint fk_deptno foreign key (deptno) references dept (deptno) ); /* create table bonus( ..
2023. 4. 26.