Tag: Row Count

Here is a simple SQL script with the help we can find the Table Row count for all tables. Yes we can find the row count using select count(*) for each table. This will be useful if you large number of tables are there in your database. Example Script: — Create a table CREATE TABLE ROW_COUNT_ALL_TABLE ( TABLE_NAME VARCHAR2(100), ROW_COUNT VARCHAR2(100) ) — PL-SQL Block to count Row Count for all tables as you specify DECLARE V_ROW_COUNT VARCHAR2(100); V_SQL_STRING VARCHAR2(1000);

» Read more