How to count tables in oracle ?

Use this to count your tables in oracle database :

Select table_name,
    user u
from user_tables

Comments