Tambahan 1

select concat ('Jakarta, ', to_char(sysdate,'DD Month YYYY'))

from dual;

Atau

select 'Jakarta, '||to_char(sysdate,'DD Month YYYY')

from dual;

select 'Jakarta, '||to_char(sysdate,'DD-MM-YYYY') ||', Indonesia'

from dual;

SELECT *

      FROM employees

WHERE first_name LIKE '%r%'

AND first_name LIKE '%A%';

ORDER BY first_name ASC;

3. Tampilkan employee_id dan tahun masuk kerja pegawai yang masuk bulan april, eptember dan desember

SELECT employee_id, TO_CHAR(hire_date, 'YYYY')

    FROM employees

WHERE TO_CHAR(hire_date, 'MM')=04

OR TO_CHAR(hire_date, 'MM')=09

OR TO_CHAR(hire_date, 'MM')=12;

Atau

SELECT employee_id, TO_CHAR(hire_date, 'YYYY')

    FROM employees

WHERE TO_CHAR(hire_date, 'MM') in ('04','09','12');

SET SERVEROUTPUT ON

SET VERIFY OFF

DECLARE

       VKODE VARCHAR(10):=&VKODE;

       VJML NUMBER;

      VRATA NUMBER (5,0);

      VTOTAL NUMBER;

       BEGIN

   select  count(employee_id), AVG(TO_NUMBER(TO_CHAR(sysdate, 'YYYY')) -TO_NUMBER( TO_CHAR(hire_date, 'YYYY'))), SUM(salary)

     INTO  VJML, VRATA, VTOTAL

     FROM employees;

         

   DBMS_OUTPUT.PUT_LINE('Kode Depart : '||VKODE);

     DBMS_OUTPUT.PUT_LINE('Jml Pegawai : '||VJML  ||' Pegawai');

     DBMS_OUTPUT.PUT_LINE('Rata-rata lama kerja : '||VRATA ||' Tahun');

     DBMS_OUTPUT.PUT_LINE('total : '||VTOTAL);

END;