Interested to Buy Any Domain ? << Click Here >> for more details...
What is the result of this query ?
SELECT * FROM EMP WHERE ROWNUM = 1
- 25 Answers
- 34028 Views
- IBM, Satyam, I also Faced
- E-Mail Answers
Answer Posted / eshwer
Hi Apps /Any one, Your right..
ROWNUM is generally used in >=, <=, <, >. But there is
exception, you can use it = also but only with 1 as
ROWNUM=1, it will display first record in table. If you use
ROWNUM=10…. Or any number other than 1 then it will not
display any records.
please you explain why its giving exception for other than ROWNUM=1.
what is the mechanism behind this..
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how do you describe O2C along with tables
In sequence i want to 11 and 15th values how we will write?
Explain oracle apps architecture.
Can u give the Documentation of Custom.pll in oracle apps
Can you explain the difference between architecture followed in 10g & 11g?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
What are do's and dont's of Interface?
what is the differences between internal requisition and internal sales order?
what are the balancing segments in AR?
tell me the scenarios of the independent in reports
please send me forms, xml pulisher questions,answers
What do you understand by concurrent programs?
Tell me how to find the custom directory in front end?
Tell me where we find the status of order information?
What do you understand by a set of books?
