it will result the count of TABLE,CLUSTER,VIEW,SYNONYM in given schema

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

Question Posted / deepshikha

15 Answers
28382 Views
IBM, Student, Wipro, I also Faced
E-Mail Answers

Answer Posted / deepshikha

it will result the count of TABLE,CLUSTER,VIEW,SYNONYM
in given schema

Is This Answer Correct ?

3 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain raise_application_error.

1042

What packages(if any) has oracle provided for use by developers?

5716

how to present a past time in hours, minutes and seconds? : Sql dba

944

What is nosql db?

923

What is a trigger word?

961

what is a database? : Sql dba

1098

What are tables in sql?

997

What are the different types of dbms?

954

What is the difference between a database and a relational database?

1035

Is keyword pl sql?

931

What is function and procedure?

984

Which certification is best for sql?

938

What is union?

1082

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3944

What are pl/sql cursors?

989