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 what is a field in a database and record in a database?

0 Answers  

write a procedure to find top second no from a list of numbers

1 Answers   ABC,

What is foreign key in sql with example?

0 Answers  

What is delimiter in pl sql?

0 Answers  

How One can easily select all even, odd, or Nth rows from a table using SQL queries?

4 Answers  

what is offset-fetch filter in tsql? : Transact sql

0 Answers  

What are the differences between implicit and explicit cursors?

0 Answers  

What is composite primary key in sql?

0 Answers  

Is sql better than excel?

0 Answers  

Mention what does plv msg allows you to do?

0 Answers  

Define union, minus, union all, intersect ?

0 Answers  

What is rank () in sql?

0 Answers