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 to do if the binary spfile is wrong for the default instance?

1075

what is IDE,DMV in sql server?

2829

How to start a specific oracle instance?

1042

When do I need to use a semicolon vs a slash in oracle sql?

1090

Please explain drop constraint oracle?

1112

How to export data to a csv file?

1312

How to retrieve the count of updated rows?

1130

How to loop through a cursor variable?

1091

Difference between oracle's plus (+) notation and ansi join notation?

1111

How to get last row id?

1001

What is format trigger?

2077

Explain what are the type of synonyms?

1130

What suggestions do you have to reduce the network traffic?

967

How to assign query results to variables?

1053

What is pragma autonomous transaction in oracle?

1074