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
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
what is global tempory table?
Tell me how to debug the report?
How many schemas we have? how many you have used?
tell me the scenarios of the independent in reports
What do you understand by concurrent programs?
Explain oracle apps architecture.
q)what are the validations in sql*loader
What is oracle soa suite?
Explain what are the tables of auto invoice?
What is a flexfield? List out its types.
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
What are the Standard Reports and Forms in HRMS?
In sequence i want to 11 and 15th values how we will write?
what are the prerequisites for costing transactions?