Rotem_fo,

After created the function you recommended, I tried a query, but it did not give me any numbers

SQL> select fname, lname, calc_age(bdate) "AGE"
2 from employee;

FNAME LNAME AGE
--------------- --------------- ---------
Franklin Wong
Alicia Zelaya
Jennifer Wallace
Ramesh Narayan
Joyce English
Ahmad Jabbar
James Borg
John Smith

8 rows selected.


Did I make any mistake? On your code, you had

create or replace function CALC_AGE (i_SSN in varchar2) return NUMBER
is
.......
.........

Do we usually use PK in the table for the function parameter? I am new to this, can you explain?

Thanks a lot.
SKY