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

What is memory optimized table?

571

In what condition is it good to disable a trigger?

552

what are the advantages of sql ? : Sql dba

541

How can you fetch first 5 characters of the string?

550

what is recursive stored procedure? : Sql dba

524

What is the need of a partition key?

530

Is pl sql different from sql?

530

What is difference between joins and union?

529

What is a scalar value in sql?

580

What is the most common sql injection tool?

543

Is sql a programming?

545

What are character functions?

628

Why is pl sql needed?

509

What is the starting oracle error number? What is meant by forward declaration in functions?

538

Can we create clustered index without primary key?

519