Arun Kumar Sabat
Monday, December 21, 2009
Oracle: Find row count in multiple Tables
use the following query to selct number of rows in multiple tables
select table_name, num_rows from user_tables where lower(table_name) in ('Table1',
'Table2',
'Table3')
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment