What is the result of this query ?

SELECT * FROM EMP WHERE ROWNUM = 1

Answer Posted / smruti

Guys,

Posting an answer is a nice effort, that means you are
trying to help other people overcome the trouble ahead.

But be cautious when posting an answer in public. Posting
wrong answers can be a sin.

Please be silent if you dont know atleast. After a damn
strong and correct answer from someone called Apps why u
people don't verify with urself. Archana don't show off
please.

SQL> SELECT * FROM EMP WHERE ROWNUM = 1;

EMPNO ENAME
---------- ----------------------------------------
1 SMRUTI

SQL> SELECT * FROM EMP WHERE ROWNUM = 22;

no rows selected

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

627


CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2082


Which oracle apps version you are very confident in?

697


What is a value set? List its various types.

646


In sequence i want to 11 and 15th values how we will write?

1568






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

654


How to move the one file from one instance to another instance? And your scripts also?

605


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

1512


Can you differentiate between mediator and osb?

621


In support project one ticket alloted which steps follows manualy tell me ?

2215


What does appl_top directory contain?

638


What are the Standard Reports and Forms in HRMS?

1764


What do you understand by soa?

680


List the various types of value set.

616


How can you achieve loose coupling in soa framework?

713