Menampilkan data karyawan mulai dari karyawan No. 100 hingga 120
---------------------script PL/SQL------------------------------
set serveroutput on
declare
vnomor number(3);
vnama varchar2(10);
vgaji number(6);
kgaris constant varchar2(60):=LPAD('-',60,'-');
begin
--tampilkan judul laporan
dbms_output.put_line('Data Karyawan');
dbms_output.put_line(kgaris);
dbms_output.put_line(rpad('No.',5,' ')||rpad('Nama',15,' ')||rpad('Gaji',6,' '));
dbms_output.put_line(kgaris);

FOR vnomor in 100..120 Loop
	Select last_name, salary INTO vnama, vgaji
	from Employees
	where employee_id=vnomor;
--tampilkan record
dbms_output.put_line(rpad(vnomor,5,' ')||rpad(vnama,15,' ')||rpad(vgaji,6,' '));
End Loop;
dbms_output.put_line(kgaris);
End;