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...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

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

Question Posted / ajitnayak

Answer Posted / ajitnayak

SELECT COUNT(DISTINCT TABLE_NAME)
FROM COLS

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between a user and a schema in oracle?

1076

what are steps for interface? where is exchange rate defined in which table?

2234

How to use like conditions in oracle?

1111

What is clustered table in Oracle?

1257

How to define an oracle cursor variable?

1090

Explain oracle 12c new features for developers?

1122

Use of an integrity constraint is better to validate data. Explain

1086

List out the difference between commit, rollback, and savepoint?

1089

What is the difference between hot backup and cold backup in oracle?

1075

Write a trigger example in oracle?

1111

How to manage transaction isolation level?

1054

What is a tns service name?

1055

what are bitmap indexes? How does they work?

2302

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1991

Explain what are the advantages of views?

1105