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

How do I find duplicates in a single column in sql?

1025

what is the difference between sql and t-sql? : Transact sql

1095

Determine if oracle date is on a weekend?

1043

What is trigger in pl sql?

1005

How many triggers can be applied on a table?

937

What are conditional predicates?

1064

What are sql queries used for?

1032

What is cost in sql execution plan?

991

What are all the common sql functions?

1036

What is sqlcontext?

1090

what are the security recommendations while using mysql? : Sql dba

1125

Which data dictionary views have the information on the triggers that are available in the database?

1245

What is the difference between local and global temporary table?

1053

What are stored procedures in mysql?

1021

Do we need to create index on primary key?

931