select count(1) from tab will give the total number of tables,views and s

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

Question Posted / gourvendra singh

Answer Posted / gourvendra singh

select count(1) from tab will give the total number of
tables,views and synonms present in the current schema.

Is This Answer Correct ?

61 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What is data modelling in sql?

964

What is a primary key? Explain

922

How to combine two stored procedures in sql?

1124

How do you update sql?

915

What is sql indexing?

965

What is varchar used for?

1025

Which language is used in sql?

992

what is schema? : Sql dba

987

What is the difference between union and union all command?

1009

What is cursor and its types?

996

define sql update statement ? : Sql dba

1051

What is a heap in sql?

994

Which version of sql do I have?

1000

What does select top 1 do in sql?

1007

Explain the purpose of %type and %rowtype data types?

875