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

What are different types of sql?

1157

what is sql? : Sql dba

1002

What is the difference between local and global temporary table?

1024

What do you understand by exception handling in pl/sql?

1011

What's the procedure?

913

What is the difference between distinct and unique in sql?

920

what are the different type of normalization? : Sql dba

1012

What is aggregate function in sql?

1020

What language is oracle sql developer?

985

What is a function in oracle pl sql?

1014

what are the different index configurations a table can have? : Sql dba

980

What is your daily office routine?

2255

How to rename a column in the output of sql query?

1063

What is difference between joins and union?

1101

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1008