What is the result of this query ?
SELECT * FROM EMP WHERE ROWNUM = 1
- 25 Answers
- 26389 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 oracle soa suite?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
How to create a purchase order without a requisition?
Can you explain the difference between architecture followed in 10g & 11g?
Plz anybody send me Technical specification for AP Interface
List the types of flexfield?
what are the prerequisites for costing transactions?
tell me the scenarios of the independent in reports
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
How can we import the data into a database using sql * loader?
please send me forms, xml pulisher questions,answers
Tell me how to find the custom directory in front end?
What is oracle soa suite and what are its different components?
What do you understand by soa?
do you know is it possible to run the interface without using oracle apps?
