Re: 오늘의 마지막 문제. 아래의 departments 테이블을 생성하시오.

[21기_윤수연]

CREATE TABLE DEPARTMENTS(
    DEPARTMENT_ID NUMBER(10) CONSTRAINT DEPARTMENTS_ID_PK PRIMARY KEY,
    DEPARTMENT_NAME VARCHAR2(100),
    MANAGER_ID NUMBER(10),
    LOCATION_ID NUMBER(10)
);

SELECT a.CONSTRAINT_NAME, a.CONSTRAINT_TYPE, a.TABLE_NAME, b.COLUMN_NAME
FROM USER_CONSTRAINTS a, USER_CONS_COLUMNS b
WHERE a.CONSTRAINT_NAME = b.CONSTRAINT_NAME
  AND a.TABLE_NAME = 'DEPARTMENTS';

INSERT INTO DEPARTMENTS
SELECT *
FROM HR.DEPARTMENTS;

SELECT *
FROM DEPARTMENTS;

COMMIT;