PL/SQL Function to Calculate Annual Income of Employee

PL/SQL Function to Calculate Annual Income of Employee:

create or replace function tot_cal(veno in number)
return number is atax number(20);
totsal number(20);
begin
select salary*12 into totsal from employee where id=veno;
atax:=Round(totsal*0.1);
return(atax);
end;

Calling Function:

select salary,tot_cal(1) from student;

 

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.