it will display the total number of tables in the schema.

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

Question Posted / shivashanker

Answer Posted / shivashanker

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What are two statement types in sql?

1033

How many tables can you join in sql?

901

How can check sql version from command line?

1014

What is on delete set null?

1039

What is data manipulation language?

1137

What is dml and ddl?

901

what is a constraint? : Sql dba

1106

How do I view a table in sql?

954

List the ways to get the count of records in a table?

853

What is crud sql?

924

Why truncate is faster than delete?

1054

What are few of the schema objects that are created using PL/SQL?

971

How many indexes can be created on a table in sql?

989

Are there any features that are decommissioned in 11g that are not present in 11g?

2069

how can you create an empty table from an existing table? : Sql dba

1080