This results the total count of tables,views,synonyms and sequences presen

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

Question Posted / rahul koshti

Answer Posted / rahul koshti

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

Is This Answer Correct ?

19 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How to make a copy values from one column to another in sql?

1037

What is an emotional trigger?

1005

What are triggers and its uses?

1050

What are the two virtual tables available at the time of database trigger execution?

1223

Which is better trigger or stored procedure?

952

What is the non-clustered index in sql?

1064

Differentiate between % rowtype and type record.

1311

What is an exception in PL/SQL? What are the two types of exceptions?

1313

What is a record in pl/sql?

1150

How to rename a table?

1028

how can you see all indexes defined for a table? : Sql dba

1000

What are the different types of dbmss?

1015

How many sql commands are there?

1118

What is the difference between a query and a report?

978

What are the different types of joins in sql?

1797