DECLARE

data_var all_objects.object_name%type;
BEGIN

FOR I IN  1..100
  LOOP
    EXECUTE IMMEDIATE 'SELECT OBJECT_NAME FROM DBA_OBJECTS WHERE OBJECT_ID='||I ; 
  END LOOP;
  
END;
/

SQL ID: grwydz59pu6mc
Plan Hash: 3684871272
select text 
from
 view$ where rowid=:1


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse      200      0.00       0.00          0          0          0           0
Execute    200      0.03       0.00          0          0          0           0
Fetch      200      0.00       0.00          0        400          0         200
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total      600      0.03       0.01          0        400          0         200

Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS   (recursive depth: 2)

Rows     Row Source Operation
-------  ---------------------------------------------------
      1  TABLE ACCESS BY USER ROWID VIEW$ (cr=1 pr=0 pw=0 time=0 us cost=1 size=15 card=1)

********************************************************************************