CURSOR

  CURSOR c_table IS

    SELECT table_name FROM user_tables WHERE table_name LIKE 'PDTABLE_12_%';

  sys_no  VARCHAR2(64);

  line_no VARCHAR2(64);

  line_id VARCHAR2(64);

  par_no  VARCHAR2(64);

  c SYS_REFCURSOR;

BEGIN

  FOR t IN c_table LOOP

    OPEN c FOR 'select LINE_NUMBER_LABEL,LINE_ID,PARTITION_NO  from ' || t.table_name;

      dbms_output.put_line('System_unique_number :' || t.table_name||line_no||line_id||parnp);

      FETCH c INTO sys_no,line_no , line_id , par_no  ;

    END LOOP;

  END LOOP;