Count number of tables in Oracle

Question

Like MySQL has "SHOW TABLES" , how do you count tables in Oracle DB. Little bit of research gave me this query:

select owner, count(*) from dba_tables

So like MySQL has a standard command, does Oracle have one?

Answer 1

try:

SELECT COUNT(*) FROM USER_TABLES;

Well i dont have oracle on my machine, i run mysql (OP comment)

at the time of writing, this site was great for testing on a variety of database types.

Answer 2

Yeah sure your query will work just modify it a little. Look here for refrence : http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_2105.htm#i1592091

Run this:

SELECT TABLE_NAME FROM DBA_TABLES;

to get list of tables.

and Run this:

SELECT Count(*) FROM DBA_TABLES;

to get the count of tables.