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

What are the different windows events activated at runtime ?

2845

What is oracle used for?

977

When do we use group by clause in a sql query?

999

What are the general rules on data consistency?

963

What is meant by a deadlock situation?

1062

In which language oracle has been developed?

1021

How to use values from other tables in update statements using oracle?

1033

What is a proxy object?

1017

What are the uses of a database trigger?

938

What is a table in oracle?

933

How to call a stored function in oracle?

959

What is partitioned table in Oracle?

1119

Explain view?

986

What is bulk copy or bcp in oracle?

1059

How to see the table columns used in an index?

972