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.

Can you skip header records while loading? : aql loader

0 Answers  

What is data type in sql?

0 Answers  

diff b/w sub query and co-relater query?

3 Answers   iFlex,

What sql database should I use?

0 Answers  

What is the difference between pl and sql?

0 Answers  

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

0 Answers   CTS,

can i create trigger on synonym is it possible or not please help me

4 Answers   CGI,

What is a sql schema used for?

0 Answers  

What is cursor in pl sql?

0 Answers  

Can we use joins in subquery?

0 Answers  

what is blob? : Sql dba

0 Answers  

Does view contain data?

0 Answers