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

Explain alias?

715


Can you create a synonym without having a table?

557


Explain the characteristics of oracle dba?

638


what is IDE,DMV in sql server?

2250


How to define a sub function?

668






How to write a left outer join with the where clause in oracle?

629


Which is faster join or subquery in oracle?

537


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

583


What is an oracle recycle bin?

551


How to create a stored procedure in oracle?

577


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.

1538


Differentiate between translate and replace?

633


What is meant by an index?

624


What is a directory object?

591


What is redo log?

626