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.

What is referential integrity ?

3 Answers   BirlaSoft,

What is cross join example?

0 Answers  

what is acid property in database? : Sql dba

0 Answers  

Is full outer join same as cross join?

0 Answers  

What is a temporal data type?

0 Answers  

Does oracle roll back the transaction on an error?

0 Answers  

How do I find duplicates in sql?

0 Answers  

What is cascade in sql?

0 Answers  

what is the purpose of update command in oracle?

7 Answers   MBT,

What does stand for in sql?

0 Answers  

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

pl/sql testing means what ...... explain process how to find pl/sql bugs

1 Answers   Zensar,