SQL

SELECT
 FIRSTNAME,
 LASTNAME,
 TO_CHAR((SELECT SYSDATE FROM dual)) AS NOW,
 TO_CHAR(DATEOFBIRTH) AS DATEOFBIRTH,
 trunc(((SELECT SYSDATE FROM dual) - DATEOFBIRTH)/365) AS AGE
FROM
 CUSTOMER;