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
- 33099 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
what is pay run id ?
Is soa a part of oracle fusion middleware?
What are the Standard Reports and Forms in HRMS?
can we use look up type instead of a pofile option?or valueset?is it possible how?
What do you understand by concurrent programs?
What is sca and how is it useful?
how can i print random rows in plsql table
How can a process be deployed in soa?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
Can you define an erp system?
Tell me how to find the custom directory in front end?
what are the balancing segments in AR?
how to print multi lay outs,muti currency,muti language in xml publisher
What does appl_top directory contain?
Are you familiar with internet architecture of oracle apps 11i?
