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 is record data type?

679

What is graph sql?

721

Which table is left in left join?

718

Explain the commit statement.

848

What is embedded sql in db2?

708

What does an inner join do?

788

How do I access sql anywhere database?

677

What is nosql vs sql?

879

Can we use delete in merge statement?

741

How do we accept inputs from user during runtime?

732

How to select unique records from a table?

773

how can we know the count/number of elements of an array? : Sql dba

776

What version is sql?

733

what is a database lock ? : Sql dba

787

What does a pl/sql package consist of?

723