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.

Create a procedure to delete certain records from a table and display the total number of records deleted in this process. (Condition for deletion can be of ur choice, for instance delete all records where eid='')

2 Answers  

What is left join in sql?

0 Answers  

What are the Diff B/W Cursor and REF Cursor

3 Answers   CTS,

Why we use join in sql?

0 Answers  

how can we find the select statement is indexed or not?

3 Answers   CTS,

how are mysql timestamps seen to a user? : Sql dba

0 Answers  

Explian rowid, rownum?

0 Answers  

what is try_catch block in procedure

0 Answers  

What is the difference between function, procedure and package in pl/sql?

0 Answers  

select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

2 Answers  

how to write date and time literals? : Sql dba

0 Answers  

Can a commit statement be executed as part of a trigger?

0 Answers