how do u know the total no of rows in a table?

Answer Posted / mohd akhtar

select sum(1) from emp

Is This Answer Correct ?    4 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to define a variable of a specific record type?

851


What is index in Oracle?

793


Can we store images in oracle database?

747


How to filter out duplications in the returning rows using oracle?

844


Difference between hot backup vs. Cold backup?

786


What is partitioned table in Oracle?

840


types of indexes and the rationale behind choosing a particular index for a situation.

2239


Explain the use of ignore option in imp command.

776


what is the scenario where you take the database to NoArchivelog mode?

2065


How translate command is different from replace?

746


What are the differences between lov and list item?

762


Give syntax for SQL and ORACLE joins.

858


Explain what are clusters?

843


Which are the five query types available in oracle?

729


Use of an integrity constraint is better to validate data. Explain

778