select count(*) from tab --it's gives total no of tables only ....not

What does “select count(*) from tab” result?

Question Posted / shanmukha srinivas

Answer Posted / shanmukha srinivas

select count(*) from tab --it's gives total no of tables only ....not gives
sequence,cluster,views....etc
ok understand.

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

how many columns can be used for creating index? : Sql dba

524

How many types of tables are there?

509

What can I use instead of union in sql?

518

What do you understand by pl/sql packages?

573

What is package in pl sql?

579

Is primary key an index?

537

Which table is left in left join?

531

How do you create an update query?

526

what are the advantages a stored procedure? : Sql dba

553

State few characteristics of pl/sql?

569

What are the most important ddl statements in sql?

577

Why we use sql profiler?

562

What are the types of sql commands?

553

What is a crud api?

502

What is rownum and rowid?

572