오라클공부 40. 실습 테이블 데이터 생성

실습 테이블 데이터 생성

 

CREATE TABLE DEPT

    (DEPTNO NUMBER(2) CONSTRAINT PK_DEPT PRIMARY KEY,

     DNAME BARCHAR2(14), LOC VARCHAR2(13) );

CREATE TABLE EMP

     (EMPNO NUMBER(4) CONSTRAINT PK_EMP PRIMARY KEY,

      ENAME VARCHAR2(10),

      JOB VARCHAR2(9),

      MGR NUMBER(4),

      HIREDATE DATE,

      SAL NUMBER(7,2),

      COMM NUMBER(7,2),

      DEPTNO NUMBER(2) CONSTRAINT FK_DEPTNO REFERENCES DEPT);

CREATE TABLE BONUS

     (ENAME VARCHAR2(10),

      JOB VARCHAR2(9),

      SAL NUMBER,

      COMM NUMBER);

CREATE TABLE SALGRADE

     (GRADE NUMBER,

      LOSAL NUMBER,

      HISAL NUMBER);