What is the result of this query ?

SELECT * FROM EMP WHERE ROWNUM = 1

Answer Posted / rao

SELECT * FROM EMP WHERE ROWNUM = 1
it will be returned only one record. we have to display the
more than records using below mentioned statement....

SELECT * FROM EMP WHERE ROWNUM < 4...

Answer is correct ... checked also

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

tell me the scenarios of the independent in reports

2110


Is soa a part of oracle fusion middleware?

607


where to define interorganization transaction charges and what are the different options?

1960


If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

1657


Can you define an erp system?

682






What is a flexfield? List out its types.

669


List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

1805


What are the benefits of using soa architecture?

711


What is oracle soa suite?

768


Tell me how to find the custom directory in front end?

666


Do you know where we can check the status of po?

642


what are the prerequisites for costing transactions?

2635


What do you understand by a set of books?

650


WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

2599


is it possible to run the interface without using oracle apps?

1519