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 do I start sql profiler?

1048

Is like operator in sql case sensitive?

1077

how to concatenate two character strings? : Sql dba

1161

what are integrity rules?

1092

What is a left join?

1006

What are different clauses used in sql?

1174

how to enter numeric values as hex numbers? : Sql dba

1100

What are sql constraints?

1228

Can you join a table to itself?

1222

Why select is used in sql?

1070

Why are sql stored procedures used?

1095

What are the three forms of normalization?

1092

What is equi join in sql?

1119

Can we use loop in sql?

1010

How do you remove duplicate records from a table?

981