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

Which join is like inner join?

1005

What is a common use of group by in sql?

1029

What is over () in sql?

927

Explain what is a column in a table?

1084

How are functions and procedures called in PL/SQL?

1195

What is the difference among union, minus and intersect?

982

How much does a sql dba make? : SQL DBA

926

what is query cache in mysql? : Sql dba

1015

What is the use of sqldataadapter?

945

which tcp/ip port does sql server run on? : Sql dba

1002

What is mutating error?

950

What is data profiling in sql?

1056

How do I send sql query results to excel?

1048

How to handle bulk data?

1298

Why primary key is required?

984