Oracle隐式游标

以下是代码片段： declare begin update departments set department_namedepartment_name=department_name; --where 1=2; dbms_output.put_line('update '|| sql%rowcount ||' records'); end; /

以下是代码片段： declare begin for my_dept_rec in ( select department_name, department_id from departments) loop dbms_output.put_line(my_dept_rec.department_id || ' : ' || my_dept_rec.department_name); end loop; end; /