--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:
Other Most Useful PLSQL Scripts:
- PL/SQL Function To Compute The Factorial Of A Number
- PL/SQL Function To Convert A Binary Number To A Decimal Number
- PL/SQL Function To Convert A Decimal Number To A Binary Number
- PL/SQL Function To Convert Ruppies(Numbers) In Words
- PL/SQL Function To Generate The Fibonacci Series
- PL/SQL Procedure To Display Monthly Calender
- PL/SQL Procedure To Reverse A String
- PL/SQL Script To Calculate Weekdays Between Two Given Dates
COMMENTS