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 is oracle used for?

534

how to handle exceptions in post production

944

How to convert characters to times in oracle?

593

How to loop through data rows in the implicit cursor?

537

Explain the use of indexes option in exp command.

590

What is connection pool in oracle?

556

How to use "while" statements in oracle?

729

What is a package in oracle?

562

How to login to the server without an instance?

616

Explain the different normalization forms?

587

Explain a private synonyms?

628

Can we call procedure inside function in oracle?

604

Is oracle a relational database?

517

How to create a new table by selecting rows from another table?

547

How to assign a table row to a record variable?

575