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

Answer Posted / nirav21686

Select Count(*) From User_Tables

Is This Answer Correct ?    16 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a cursor variable?

784


How a database is related to tablespaces?

771


What happens if variable names collide with table/column names?

826


What is transaction control statement and how many types of transaction control statement in Oracle?

807


Why packages are used in oracle?

782


What are the differences between primary key and unique key?

723


What is index in Oracle?

792


What are the different editions of oracle?

825


Why do we need oracle client?

683


If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

1979


How to run create database statement?

763


15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

1989


Are truncate and delete commands same? If so why?

830


How to create an oracle database?

767


What is a nested table and how is it different from a normal table?

795