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
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
Which oracle apps version you are very confident in?
What is a value set? List its various types.
In sequence i want to 11 and 15th values how we will write?
Tell me how to find the custom directory in front end?
How to move the one file from one instance to another instance? And your scripts also?
is it possible to run the interface without using oracle apps?
Can you differentiate between mediator and osb?
In support project one ticket alloted which steps follows manualy tell me ?
What does appl_top directory contain?
What are the Standard Reports and Forms in HRMS?
What do you understand by soa?
List the various types of value set.
How can you achieve loose coupling in soa framework?