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.

Do stored procedures prevent sql injection?

0 Answers  

What is plpgsql language?

0 Answers  

What is record data type?

0 Answers  

4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

1 Answers   Fintellix,

What is parallel hint?

0 Answers  

what is innodb? : Sql dba

0 Answers  

How do I view output in sql developer?

0 Answers  

Is left join faster than join?

0 Answers  

Write a unique difference between a function and a stored procedure.

0 Answers  

What does “select count(*) from tab” result?

15 Answers   IBM, Student, Wipro,

display your age in months?

2 Answers  

What is percent sign in sql?

0 Answers