SELECT COUNT(1) FROM TAB ANS:It gives the total number of tables,views,s

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

Question Posted / vishnu

Answer Posted / vishnu

SELECT COUNT(1) FROM TAB

ANS:It gives the total number of tables,views,synonyms
present in that schema.

Is This Answer Correct ?

23 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What are the methods of filing?

935

tell me about various levels of constraint. : Sql dba

1034

What are the properties of a transaction?

1128

how to start mysql server? : Sql dba

1195

How to write a query to show the details of a student from students table whose

994

What is left inner join in sql?

1041

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

1002

What are the possible values for the boolean data field?

961

is it possible to pass an object or table to a procedure as an argument?

1129

what is a composite primary key ? : Sql dba

1050

Which operator is used in query for pattern matching?

1087

Why use stored procedures?

1081

What is the use of pl/sql table?

1063

Is pl sql a programming language?

988

what are the join types in tsql? : Transact sql

1064