Soal Basis Data Oracle Conversion Functions

Soal Basis Data Oracle Conversion Functions - Berikut adalah soal latihan basis data oracle mengenai conversion functions dengan jawaban lengkap.



1. You need to display the HIRE_DATE values in this format: 25th of July 2002. Which SELECT statement would you use?

SELECT TO_CHAR(hire_date, 'ddth "of" Month YYYY') FROM employees;



2. Sysdate is 12-MAY-2004. You need to store the following