Tuesday, July 29, 2014

count all table in a database in oracle query

SELECT COUNT(*) FROM USER_TABLES;
 
or
 
SELECT Count(*) FROM DBA_TABLES; 

No comments:

Post a Comment