title: Pl-sql Procedure to print table details
body: <p>SQL. I have created 1 procedure but I am not getting the desired output. My procedure is below:</p>
  
  <pre><code>--/
  CREATE OR REPLACE procedure Update_TB_INTERACTLOG
  IS
  BEGIN
      FOR records in (select TNAME from tab where TNAME like 'TB_INTERACTLOG%' and TABTYPE = 'TABLE')
      LOOP
          dbms_output.put_line(records.TNAME||' modified');
      END LOOP;
  END;
  /
  </code></pre>
  
  <p>There are 7 records I am getting from select query.</p>
  
  <p>This I am getting in Log Output.</p>
  
  <p><strong>13:10:02  [CREATE - 0 row(s), 0.031 secs]  Command processed. No rows were affected
  ... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.031/0.000 sec [0 successful, 1 warnings, 0 errors]</strong></p>