It's not a secret anymore!*
The moose likes Oracle/OAS and the fly likes how to  find  all tablename and rowcount of each table from database? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "how to  find  all tablename and rowcount of each table from database?" Watch "how to  find  all tablename and rowcount of each table from database?" New topic
Author

how to find all tablename and rowcount of each table from database?

suresh sargar
Greenhorn

Joined: Feb 10, 2009
Posts: 10
please help me for the query..

i want tablename and row count of each table.

i knew one query select table_name ,num_rows from user_tables;

but if i update some table that updated row count will be not gettting with this query...

can you suggest me any other query how to get updateable result..?
 
 
subject: how to find all tablename and rowcount of each table from database?
 
Similar Threads
Number of rows in a table?
createQuery() return types
Regarding PreparedStatement
a basic question
mysql & incomplete insertions!