how to get count of tables in particular database in Oracle?

how to get count of tables in particular database in Oracle?

Question Posted / nlakshmithota

3 Answers
4596 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to get count of tables in particular database in Oracle?..

Answer / nirav21686

Select Count(*) From User_Tables

Is This Answer Correct ?

16 Yes

0 No

how to get count of tables in particular database in Oracle?..

Answer / ajitnayak

SELECT COUNT(DISTINCT TABLE_NAME)
FROM COLS

Is This Answer Correct ?

0 Yes

0 No

how to get count of tables in particular database in Oracle?..

Answer / abc

select count(*) from tab;

Is This Answer Correct ?

1 Yes

2 No

Post New Answer

More Oracle General Interview Questions

What would you do with an in-doubt distributed transaction?

How translate command is different from replace?

What's dateware house and what's clustor with practicle example

How to use "out" parameter properly?

What is a relational database management system?

What are the oracle built-in data types?

why can't we assign not null constraint as table level constraint

3 Answers CTS, Wipro,

What is an Index ? How it is implemented in Oracle Database ?

How to view all columns in an existing table?

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

What is the difference between view and materialized view in Oracle?

0 Answers MCN Solutions,

What are the different types of synonyms?

For more Oracle General Interview Questions Click Here

Categories

Oracle General (1789)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)
Oracle Security (38)
Oracle Forms Reports (510)
Oracle Data Integrator (ODI) (120)
Oracle ETL (15)
Oracle RAC (93)
Oracle D2K (72)
Oracle AllOther (241)