Thursday, 24 November 2011

interview question

How to find the number of tables and total number of rows in a schema?

ANS:

Select count(table_name) totaltables,sum(num_rows) totalrows from user_tables;

No comments:

Post a Comment