PL/SQL Procedure For Counting All Tables And Respective Rows From Database

--Procedure For Counting All Tables And Respective Rows From Database

CREATE OR REPLACE PROCEDURE proc_count_tab_rec IS

  CURSOR cur_tname IS

    SELECT tname FROM tab WHERE tabtype = 'TABLE';

  v_count NUMBER;

BEGIN

  DBMS_OUTPUT.put_line('Table Name                            Records');

  DBMS_OUTPUT.put_line('---------------------------------------------');

  FOR i IN cur_tname LOOP

    EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM ' || i.tname

      INTO v_count;

   DBMS_OUTPUT.put_line(RPAD(i.tname, 35, ' ') || LPAD(v_count, 10, ' '));

  END LOOP;

END proc_count_tab_rec;

/

Other Most Useful PLSQL Scripts:

1. PL/SQL Function To Compute The Factorial Of A Number
2. PL/SQL Function To Convert A Binary Number To A Decimal Number
3. PL/SQL Function To Convert A Decimal Number To A Binary Number
4. PL/SQL Function To Convert Ruppies(Numbers) In Words
5. PL/SQL Function To Generate The Fibonacci Series
6. PL/SQL Procedure To Display Monthly Calender
7. PL/SQL Procedure To Reverse A String
8. PL/SQL Script To Calculate Weekdays Between Two Given Dates