Tab is system view which will provide you the list of table,view,cluster,

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

Question Posted / sunil

Answer Posted / sunil

Tab is system view which will provide you the list of
table,view,cluster,synonym in the current schema .

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to avoid duplicate records in a query?

1008

How do I order by ascending in sql?

1024

Can a key be both primary and foreign?

995

What does closing a cursor do?

1322

define sql update statement ? : Sql dba

1123

What are different types of queries in sql?

1121

What is sql resultset?

989

Can we use having without group by in sql?

983

Define concurrency control. : Transact sql

1192

What does select top 1 do in sql?

1098

What is union, minus and interact commands?

1299

Is there a 64 bit version of ssms?

961

How do I view tables in sql developer?

951

Explain what is a subquery ?

1189

What is secondary key?

934