Cursor writing for Oracle dynamic table names

During development, we often encounter the cursor Writing of dynamic table names, which happens in the work, as shown below:

 

Declare
Stralltable varchar2 (100 );
Type cur_typ is ref cursor;
C cur_typ;

C_id number (18 );
C_code varchar2 (100 );
Begin
For c_table in (select T. table_name
From user_tab_columns t
Where T. table_name like upper ('pne _ % ')
And T. column_name = 'code') loop

Stralltable: = 'select ID, code from' |
C_table.table_name;
Open C for stralltable;
Loop
Fetch C
Into c_id, c_code;
Exit when C % notfound;

-- You can write your own processing code here.
End loop;

Close C;
End loop;
End;