Oracle GREATEST functionOracle GREATEST fonksiyonu

En büyük date alanı olan sysdate+2′yi döndürür.

SELECT  GREATEST(SYSDATE,SYSDATE+1,SYSDATE+2) FROM DUAL ;

Oracle EXTRACT functionOracle EXTRACT fonksiyonu

Yıl bilgisini döner.

SELECT EXTRACT(YEAR FROM SYSDATE) AS YEAR FROM DUAL;

Ay bilgisini döner.
SELECT EXTRACT(MONTH FROM SYSDATE) AS M FROM DUAL;

Gün bilgisini döner.
SELECT EXTRACT(DAY FROM SYSDATE) AS D FROM DUAL;