Oracle Pl/Sql: Extrair dia, mês, ano de uma data

SELECT EXTRACT(DAY FROM SYSDATE) AS DIA
      ,EXTRACT(MONTH FROM SYSDATE) AS MES
      ,EXTRACT(YEAR FROM SYSDATE) AS ANO
  FROM DUAL;