This content has been marked as final. Show 2 replies
dept_r.deptno does not contain all departments. in a for-loop, the record-variable contains only one record, and that record is different for every roundtrip of the loop. And for sure the two cursors you show are not the same, as one selects all emps, and the other one has a restriction on the dept_no.