Oracle cursors-iterates through the data in the table (table name) and executes

The Oralce table contains a field that stores the table name, queries all the table names in the table (that is, the table name result set), and executes the result set from the table name result set:

DeclareV_ccountvarchar2( -); --defining a cursor variable  cursorC_job is  --query all table names in this table    SelectTableName fromTbname; C_row C_job%RowType;begin  --cyclic pending data, which is the result set found above   forC_rowinchC_job Loop---Executes a statement from the table name of the loop and inserts    ExecuteImmediate'Select COUNT (1) from' ||C_row.tablename intoV_ccount; Insert  intoTb_count (tbname2, Ccount)Values(C_row.tablename, V_ccount); --Dbms_output.put_line (v_ccount);  EndLoop--End of Cycle  Commit;End;