Tambahan 2

select last_name as NAMA, salary as GAJI_POKOK, salary + 1000 as TOTAL_GAJI

from employees;

select last_name as "Nama", salary as "Gaji Pokok", salary + 1000 as "Total Gaji"

from employees;

select last_name as "Nama", salary as "Gaji Pokok", salary * 0.5 as "Bonus", (salary+(salary * 0.5))*0.1 as "Pajak", salary+(salary * 0.5)-((salary+(salary * 0.5))*0.1) as "Gaji Bersih"

from employees;

select last_name, to_char (hire_date,'DD MONTH YYYY')

from employees;

select last_name, job_id, salary, decode (commission_pct,null,0,commission_pct)+50

from employees;

select last_name || q'b 'is a' b' || job_id as "Employee Details"

from employees

select distinct department_id

from employees;

select count (department_id)

from employees;

select department_id, count (*)

from employees group by department_id order by count (*);

select to_char (hire_date, 'yyyy'), count (*)

from employees group by to_char (hire_date, 'yyyy')

order by to_char (hire_date, 'yyyy');

set serveroutput on

declare

  event varchar2(15);

begin

  event := q'aFather's Daya';

  dbms_output.put_line('3rd unday in june is : ' ||event);

  event := q'bMother's Dayb';

  dbms_output.put_line('2nd sunday in may is : ' ||event);

end;

set serveroutput on

declare

  univ varchar2(100);

begin

   univ := 'UNIVERSITAS BUDI LUHUR';

  dbms_output.put_line(univ);

  end;

set serveroutput on

declare

  panjang number(20);

  lebar number(20);

  luas number(20);

begin

  panjang :=10;

   lebar :=5;

   luas := panjang*lebar;

  dbms_output.put_line('Panjang = '||panjang);

 dbms_output.put_line('Lebar = '||lebar);

 dbms_output.put_line('Luas = '||panjang||' *' ||lebar||' = ' ||luas);

  end;