How to iterate through the result of a PLSQL Select
try using CURSOR FOR LOOP
.
Probably it may look as shown below (not tried).
BEGINFOR item IN(Select table_name,column_name,num_rows from all_tab_cols join all_tables using (table_name) where column_name = 'EmployeeId' and num_rows > 0)LOOPDBMS_OUTPUT.PUT_LINE(item.table_name || ' ' || item.column_name ||' '||item.num_rows);END LOOP;END;