
显式复制set serveroutput on declare cursor emp_cur ( p_deptid in number) is select * from employees where department_id = p_deptid; l_emp employees%rowtype; begin dbms_output.put_line(Getting employees from department 30); open emp_cur(30); loop fetch emp_cur into l_emp; exit when emp_cur%notfound; dbms_output.put_line(Employee id || l_emp.employee_id || is ); dbms_output.put_line(l_emp.first_name || || l_emp.last_name); end loop; close emp_cur; dbms_output.put_line(Getting employees from department 90); open emp_cur(90); loop fetch emp_cur into l_emp; exit when emp_cur%notfound; dbms_output.put_line(Employee id || l_emp.employee_id || is ); dbms_output.put_line(l_emp.first_name || || l_emp.last_name); end loop; close emp_cur; end; / 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46.47.48.49.50.51.


相关文章



精彩导读


热门资讯
关注我们
