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 audit logout in sql profiler?

1073

What does the file extension accdb stand for?

1015

how to enter characters as hex numbers? : Sql dba

1102

How does a trigger work?

1144

How to select random rows from a table?

1134

What is the difference between subquery and correlated query?

1113

what are numeric data types? : Sql dba

1111

Explain cursor types?

1083

How do you write a subquery?

1070

How delete all data from table in sql?

1071

How would you pass hints to the sql processor?

1039

explain the difference between delete , truncate and drop commands? : Sql dba

1146

What is compute?

1149

How to run sql commands in sql*plus?

1251

what is data control language? : Sql dba

1067