Answer / sudheer

Will display the count of the Tables on the Schema.

Answer / rahul koshti

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

Answer / ashwin

No of tables and views in schema...........i've tasted
it........

Answer / deepshikha

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

Answer / nisha

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

Answer / umesh h

suppose a table is there with the name tab
then count of rows in that table will be displayed.
else count of all the logical objects under one schema
will be displayed.

Answer / vijay

it will result number of records in a table

Answer / a

It will not return the data dictionary tables

Answer / shanmukha srinivas

select count(*) from tab --it's gives total no of tables only ....not gives
sequence,cluster,views....etc
ok understand.

Answer / brajesh kr.

select count(1) from table. will return values without null
values. count(*) will return values aceept null also.

Explain the purpose of %type and %rowtype data types with the example?

0 Answers  

Which is the correct statement about truncate and delete?

0 Answers  

Why do we need pl sql?

0 Answers  

What is the difference between microsoft sql and mysql?

0 Answers  

What is the difference between the sql*loader and import utilities? : aql loader

0 Answers  

What is having clause in sql?

0 Answers  

What are all the different normalization?

0 Answers  

explain the difference between myisam static and myisam dynamic. : Sql dba

0 Answers  

Do ddl statements need commit?

0 Answers  

what are all types of user defined functions? : Sql dba

0 Answers  

Is a table valued function object?

0 Answers  

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

0 Answers