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;