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