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 query execution plan in sql?

1193

How do I sort a table in sql?

1051

what is denormalization. : Sql dba

1120

what is the difference between clustered and non clustered index in sql? : Sql dba

1131

What is a pdo connection?

1050

What is structural independence and why is it important?

1031

What is cursor explain with example?

992

Explain aggregate functions are available there in sql?

1012

What is pivot query?

1082

Can we group by two columns in sql?

1001

Do we need to create index on primary key?

931

How to process query result in pl/sql?

1136

How do you take the union of two tables in sql?

989

What is the difference between union and union all command?

1096

what is a table in a database ? : Sql dba

1047