contoh cursor

declare
id_cari employees.employee_id%type;
nama_cari employees.first_name%type;
nama_depan employees.first_name%type;
gaji employees.salary%type;
departemen departments.department_name%type;


begin
nama_id:='&masukkan_id';



select employee_id, salary, departmnt_name
into id, gaji, depatemen
from employees natural join jobs
where employee_id=id_cari;

dbms_output.put_line('pegawai bernama '||nama_depan||' jabatan '||jabatan||'gaji '||gaji);

if(gaji>5000)then
dbms_output.put_line('gaji susan gede');



elsif(gaji<5000)then
dbms_output.put_line('gaji susan kecil');



end if;
end;
/