saravannap
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
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment