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

Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Question Posted / nlakshmithota

3 Answers
5800 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 is concurrency in oracle?

Is insert autocommit in oracle?

What is the difference between translate and replace in oracle?

What is meant by joins?

How to end the current transaction in oracle?

Can you tell me how to add new column in existing views?how?How is possible?

What is pragma autonomous transaction in oracle?

Explain constraining triggers.

What is rowid and rownum in oracle?

What is the use of aggregate functions in oracle?

What is an anonymous block?

How do I learn what codesets are available in oracle?

For more Oracle General Interview Questions Click Here

Categories

Oracle General (1809)
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)