PL/SQL Function to Find Highest Salary of Employee

PL/SQL Function to Find Highest Salary of Employee:

create or replace function hig_sal
return varchar is
vname varchar(15);
begin
select name into vname from employee where salary=(select max(salary) from employee);
return(vname);
end;

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.