Select Count(*) From User

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

Question Posted / nirav21686

Answer Posted / nirav21686

Select Count(*) From User_Tables

Is This Answer Correct ?

16 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What happens to the indexes if a table is recovered?

948

How to check database size in Oracle?

1130

What are the major difference between truncate and delete?

996

How to define an external table with a text file?

1025

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2440

What is a subquery?

1064

How can I get column names from a table in oracle?

996

What privilege is needed for a user to query tables in another schema?

929

What privilege is needed for a user to delete rows from tables in another schema?

1024

How to return top 5 rows in oracle?

997

How can you use check constraints for self referential integrity?

922

Explain a segment?

1033

What happens to the current transaction if the session is killed?

935

What are the attributes of the cursor?

944

How to compare dates in oracle sql?

1056