hi,

i have a table called nav_emp

select * from nav_emp------->gives all the details of the table

select trunc(sysdate) - trunc(hiredate) from nav_emp----> gives the rowwise info abt the days difference b/w each record and sysdate.

my requiremnt: the above value should be shown alongside all the records.that is an extra column should appear beside each record indicating the days diff .