第11篇PLSQL高级特性.ppt

CREATE OR REPLACE PROCEDURE multi_query (p_col VARCHAR2,p_condition VARCHAR2,p_value VARCHAR2) AS TYPE t_cursor IS REF CURSOR; v_cursor t_cursor; lv_query VARCHAR2(200); v_empno employees.employee_id%TYPE; v_fname employees.first_name%TYPE; v_lname employees.last_name%TYPE; v_sal employees.salary%TYPE; v_deptno employees.department_id%TYPE; BEGIN lv_query:=SELECT mployee_id,first_name,last_name,salary, department_id FROM employees WHERE ||p_col||p_condition|| :ph_value; * OPEN v_cursor FOR lv_query USING p_value; LOOP FETCH v_cursor INTO