[Oracle] procedure 기본

select e.*, d.department_name from employees e, departments d
where e.department_id = d.department_id