Nailuvar Education Center

10 Jun

Using oracle built in function

Posted by massri, under Oracle

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;

One Response to “Using oracle built in function”

[...] lihat contoh [...]