This results the total count of tables,views,synonyms present in a schema

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

Question Posted / nisha

Answer Posted / nisha

This results the total count of tables,views,synonyms
present in a schema.

Is This Answer Correct ?

3 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Why is nosql good?

976

what is log shipping? : Sql dba

1056

Explain the savepoint statement.

1038

what are dynamic queries in t-sql? : Transact sql

961

How do I enable sql encryption?

966

How to change the order of columns in Oracle SQL Plus ?

993

Is primary key always clustered index?

945

What is procedure explain with program?

949

Can you have more than one key in a database?

890

Why having clause is used in sql?

926

Why truncate is faster than delete?

1053

Why is partition used in sql?

1049

Why stored procedure is faster than query?

949

When is the update_statistics command used?

1046

What is example of database?

985