Getting Row_Count of all tables in a particular User
execute dbms_stats.gather_schema_stats ('scott');
select table_name, num_rows from user_tables order by table_name;
Subscribe to:
Post Comments (Atom)
...........SQL Queries, Sub Queries, Correlated Sub Queries,PL/SQL,ERRORS,Exceptions,Procedures,Functions,Packages..............etc.......
No comments:
Post a Comment