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
- 32471 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 global tempory table?
Plz anybody send me Technical specification for AP Interface
tell me the scenarios of the independent in reports
Is soa a part of oracle fusion middleware?
What are the Standard Reports and Forms in HRMS?
In support project one ticket alloted which steps follows manualy tell me ?
What are the different components you should consider while defining a responsibility in oracle apps?
Explain oracle apps architecture.
What do you understand by concurrent programs?
List the various types of value set.
what are the balancing segments in AR?
How can you achieve loose coupling in soa framework?
what are the different transaction clauses in AR?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
