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;
/
GARUDA AKAN MAAMPU TERBANG TINGGI
Kamis, 11 November 2010
Langganan:
Posting Komentar (Atom)

0 komentar:
Posting Komentar