7.pdf

--7 SENTENCIA QUE ALIMENTA CURSOR SELECT j.JOB_TITLE , e.salary from employees e inner join jobs j on j.job_id=e.job_id; --7 CURSOR declare cursor cursor1 is SELECT j.JOB_TITLE , e.salary from employees e inner join jobs j on j.job_id=e.job_id; begin for e in cursor1 loop if e.salary > 5000 then dbms_output.put_line(j.JOB_TITLE); end loop; end;