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

Answer Posted / abc

select count(*) from tab;

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain oracle’s system global area (sga).

626


Can we save images in a database and if yes, how?

594


How to specify default values in insert statement using oracle?

564


How to define and use table alias names in oracle?

509


Difference between varchar and varchar2 data types?

666






What is blob data type in oracle?

561


How do you find current date and time in oracle?

590


What is key preserved table?

566


I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

1704


What is a database table in oracle?

572


What is the difference between alert log file and tarce file ?

1634


hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1565


How to check your oracle database 10g xe installation?

581


What is merge in oracle?

561


How to rollback the current transaction in oracle?

538