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

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

2591


what is global tempory table?

6294


Tell me how to debug the report?

637


How many schemas we have? how many you have used?

1608


tell me the scenarios of the independent in reports

2045






What do you understand by concurrent programs?

619


Explain oracle apps architecture.

760


q)what are the validations in sql*loader

1737


What is oracle soa suite?

761


Explain what are the tables of auto invoice?

646


What is a flexfield? List out its types.

662


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

1798


What are the Standard Reports and Forms in HRMS?

1770


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

1568


what are the prerequisites for costing transactions?

2631