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 omit columns with default values in insert statement in oracle?

579

definition of cluster and non-clustered index?

2479

How many types of cluster table in Oracle?

579

How to create a new table in your schema?

607

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

1927

Please explain oracle data types with examples?

590

How to write text literals in oracle?

614

List out the types of joins.

595

Explain mutating triggers.

577

State some uses of redo log files?

568

1) Does oracle have any table which contain all the exceptions and it's code internally?

1282

What is oracle join syntax?

570

Explain how are indexes update?

623

What are the various constraints used in oracle?

556

Will you be able to store pictures in the database?

642