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 does (+) mean in sql joins?

1049

Mention what is the plv (pl/vision) package offers?

1094

Show code of a cursor for loop.

1046

How do I count records in sql?

981

What is the plv (pl/vision) package offers?

1034

Explain what is an index?

1038

What is normalization in a database?

1145

What is a rank in sql?

944

how to return query output in html format? : Sql dba

1060

What is a call statement? Explain with an example.

993

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2211

Is vs as in pl sql?

971

What is secondary key?

921

What is the purpose of design view?

1000

How many sql databases can you have on one server?

1064