SELECT COUNT(DISTINCT TABLE

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

Question Posted / ajitnayak

Answer Posted / ajitnayak

SELECT COUNT(DISTINCT TABLE_NAME)
FROM COLS

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to run create database statement again?

1147

How to export your connection information to a file?

1121

What is the usage of synonyms?

1133

How to execute a stored program unit?

1069

What are the limitations of check constraint?

1022

How to change user password in oracle?

1020

What is a sub query? What are its various types?

1163

When do you get a .pll extension in oracle? Explain its importance

1031

What are the attributes of the cursor?

995

What is Library Cache in Oracle?

1136

What is snapshot is too old? Give and example for better understand.

1599

What are the set operators union, union all, minus & intersect meant to do?

983

What are ddl statements in oracle?

1071

How to do a full database export?

1098

How many types of auditing in Oracle?

1029