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

How do I start sql profiler?

1001

How can a pl sql block be executed?

949

Define implicit and explicit cursors.

1150

In what condition is it good to disable a trigger?

1016

How do I get sql certification?

976

Write the alter statement to enable all the triggers on the t.students table.

1128

What is graph sql?

996

What are the advantages of sql?

1056

What is meant by truncate in sql?

1070

How do you delete data from a table?

1048

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

1070

How do I view stored procedures?

980

What is the difference between inner join and left join?

995

How do you modify a column in sql?

1002

What does varchar include?

954