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?

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

How to speed up webrick?

1076


Difference between cartesian join and cross join?

1040


How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2123


What is not equal to in oracle?

1003


How to display employee records who gets more salary than the average salary in the department?

1065


What is a view and how is it different from a table?

1045


Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2123


How does Oracle guarantee data integrity of data changes?

2388


What are the restrictions in a oracle read only transaction?

1034


What are the limitations of check constraint?

1033


defination of bitmap index

2125


How can you use check constraints for self referential integrity?

970


If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2292


How to sort output in descending order in oracle?

1045


Explain the use of parfile option in exp command.

1069