Returning multiple values with SELECT FOR LOOP
Oracle EE 11gR1
PL/SQL
OEL 5.8
===========
Would like to know how to do the following?
for x, y in (select name, street
from employees
where hire_date < sysdate - 100)
loop
....
In other words, is there a way to handle 2 (or more) values in a SELECT FOR LOOP structure? If not, then how to accomplish the same task.
The above does not work of course. :-)
Appreciate any and all advice.