05 PLSQL程序设计 - 2-过程函数.pptVIP

例8.10 创建函数，从scott.emp表中查询指定职工的工资。 CREATE OR REPLACE FUNCTION select_sal(no scott.emp.empno%TYPE) RETURN scott.emp.sal%TYPE IS salary scott.emp.sal%TYPE; BEGIN SELECT sal INTO salary FROM scott.emp WHERE empno=no; RETURN salary; EXCEPTION WHEN NO_DATA_FOUND THEN RETURN 0; END; 例8.11 创建函数，从scott.emp表中查询指定职工的工资和姓名。 CREATE OR REPLACE FUNCTION select_name_sal( v_empno in number, v_name out varchar2) RETURN number IS v_result number; BEGIN SELECT sal ,ename INTO v_result ,v_name FROM emp WHERE empno= v_empno; RETURN v_result; EXCEPTION WHEN NO_DATA_FOUND THEN dbms_output.put_line(无符合要求的记录); v_