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 are the differences between in and exists clause?

1111

how can we know the count/number of elements of an array? : Sql dba

1060

What is faster join or subquery?

1011

How can we make an if statement within a select statement?

1013

Why is sharding used?

995

What is the command used to fetch the first 5 characters of a string?

1209

how to get help information from the server? : Sql dba

940

What is the purpose of a sql?

977

Is not equal in sql?

1012

Why we use join in sql?

973

How do sql databases work?

998

What are the built in functions of sql?

1030

What is sql constant?

1034

What is synchronized subquery?

1168

Does view store data in sql?

963