Berikut dijelaskan contoh-contoh penggunaan fungsi-fungsi oracle yang sudah di post berikutnya;

Penggunaan UPPER dan LOWER

SQL> select UPPER(first_name) T1, LOWER(last_name) T2 from employees;

SQL>select UPPER('Nailuvar Education Center') as TEST_UPPER from dual;

Contoh Penggunaan fungsi CONCAT

SQL> select CONCAT('My Name is ', first_name) name from employees;

SQL>select CONCAT('Nailuvar ', ' Education Center') as header from dual;