文件名称:eg for循环-Unix基础与Shell编程技术培训
文件大小:4.68MB
文件格式:PPT
更新时间:2024-05-12 12:28:23
Unix相关
eg4: for循环 declare cursor c(v_deptno emp.deptno%type,v_job emp.job%type) is select ename,sal from emp where deptno = v_deptno and job = v_job; begin for v_temp in c(30,'CLERK') loop dbms_output.put_line(v_temp.ename); end loop; end; 演示: