CREATE TABLE emp_dept(

dept_name, first_name, last_name

) ORGANIZATION EXTERNAL

( TYPE ORACLE_DATAPUMP

DEFAULT DIRECTORY DATA_PUMP_DIR

LOCATION('emp_dep.exp')

)AS SELECT d.department_name, e.first_name, e.last_name

FROM employees e

JOIN departments d

ON e.department_id = d.department_id;


실력좋으면 말이지

ㅇㅅㅇ폐급일을 할리가없지