Post by dejohnny on May 13, 2012 19:16:56 GMT -5
SELECT TABLE_NAME, NUM_ROWS
ALL_ALL_TABLES is data dictionary view. This view lists all the tables in the database. but if you want to list a certain schema or owner's list of tables then you can add this
WHERE OWNER = 'OWNERNAME'
here 'OWNERNAME' is whatever owner schema you want to list. for example it can be scott or systme or whatever. Moreover this view lists only the tables not views. There is a seperate DD view of the list of view that is ALL_VIEWS. You can also describe the ALL_ALL_TABLES to see other useful information it can provide about tables in the database .