Vision: Be a light wherever God sent

Have you need to count all rows on each table in your ORACLE database? If you count one by one, it will take a lot of your time.  So, for the efficient way, you can use steps and syntax below : 1. spool on you query on sqlplus. Syntax: SQL> spool on SQL> spool C:\AllRowCount_all.txt It used to save all your current queries and the result. 2.  Run this query below : SQL> set serveroutput on SQL> declare 2  numrows integer; 3  cursor c1 is select table_name from user_tables order by table_name; 4  function rowcount(tablename in user_tables.table_name%type) 5  return integer  [ Read More ]