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

Explain table?

1057

What is query image?

921

How to create an oracle database manually?

1017

Are truncate and delete commands same? If so why?

1072

What is bulk collect in oracle?

953

How to test null values?

1039

How to retrieve data from an cursor to a record?

1008

How to run queries on external tables?

985

what is a Nested Loop join?

2035

How to convert a string to a date in oracle database?

997

What is BBED in Oracle?

1086

Is there an oracle sql query that aggregates multiple rows into one row?

930

How does one get the view definition of fixed views/tables?

966

IS it possible to built the oracle database without setting the kernal parameters?

2268

Who developed oracle & when?

937