CREATE  FUNCTION get_sal(no NUMBER)
RETURN NUMBER IS salary NUMBER(6,2);
BEGIN
    SELECT sal INTO salary FROM emp where empno=no;
    RETURN salary;
END