SQL> CREATE TABLE t (date_of_birth DATE);
  
Table created.
  
SQL> INSERT INTO t VALUES (TO_DATE('19481201','YYYYMMDD'));
SQL> INSERT INTO t VALUES (TO_DATE('19501202','YYYYMMDD'));
SQL> INSERT INTO t VALUES (TO_DATE('19621203','YYYYMMDD'));
SQL> INSERT INTO t VALUES (TO_DATE('19741204','YYYYMMDD'));
SQL> INSERT INTO t VALUES (TO_DATE('19810401','YYYYMMDD'));
sQL> INSERT INTO t VALUES (TO_DATE('19931231','YYYYMMDD'));
SQL> INSERT INTO t VALUES (TO_DATE('19980606','YYYYMMDD'));
SQL> COMMIT;
  
Commit complete.
  
SQL> SELECT TO_CHAR(x.dob,'fmMM/DD/YYYY')            date_of_birth
  2  ,      TO_CHAR(SYSDATE,'fmMM/DD/YYYY')          today
  3  ,      x.age_in_yrs
  4  ,     (TRUNC(SYSDATE)
  5         -
  6         ADD_MONTHS(x.dob, 12 * x.age_in_yrs))    days_remainder
  7  FROM  (SELECT TRUNC(t.date_of_birth) dob
  8         ,      TRUNC(MONTHS_BETWEEN(TRUNC(SYSDATE)
  9                      ,              TRUNC(t.date_of_birth)) / 12) age_in_yrs
 10         FROM   t) x
 11  /
  
DATE_OF_BI TODAY      AGE_IN_YRS DAYS_REMAINDER
---------- ---------- ---------- --------------
12/1/1948  12/2/2003          55              1
12/2/1950  12/2/2003          53              0
12/3/1962  12/2/2003          40            364
12/4/1974  12/2/2003          28            363
4/1/1981   12/2/2003          22            245
12/31/1993 12/2/2003           9            336
6/6/1998   12/2/2003           5            179
  
7 rows selected.
  
SQL>