[Oracle] PL/SQL SELECT d.department_id, d.department_name, e.last_name, l.city FROM departments d left join employees e on d.manager_id = e.employee_id left join locations l on d.location_id = l.location_id; 실행결과 IT/Oracle 2021.04.23
[Oracle] procedure 기본 select e.*, d.department_name from employees e, departments d where e.department_id = d.department_id IT/Oracle 2021.04.22
[Oracle] 예약 select문 select * from reservation; create sequence reservation_no start with 6 increment by 1; drop sequence reservation_no; commit; IT/Oracle 2021.04.21
