Sunday, February 22, 2009

Write a function to return minimum salary from given department number .

SQL>
1 create or replace function minsalary(id number);
2 2 return number is;
3 3 sa number(7,2);
4 4 begin
5 5 select min(sal)into sa from emp where deptid:=di;
6 6 return sa;
7* 7* end;
SQL> /

Output :
SQL> select min(salary) from emp_college
2 /

MIN(SALARY)
-----------
4000