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 is exception handling handled in mysql? : Sql dba

1125

Can we group by two columns in sql?

1044

What are procedures used for?

1034

Write a query to find the names of users that begin with "um" in sql?

1041

Which sql statement is used to delete data from a database?

1002

Can we have two clustered index on a table?

1075

Why is pl sql used?

1024

What is oracle sql developer?

1117

How delete a row in sql?

1039

What is the difference between union and union all command?

1143

what is datawarehouse? : Sql dba

1061

How to read/write files from pl/sql?

1080

How we can update the view?

1096

What is the primary use of normalization?

1053

Why is partition used in sql?

1180