What is the result of this query ?
SELECT * FROM EMP WHERE ROWNUM = 1
Answer Posted / apps
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.
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
How do you register report in oracle apps?
What is a value set? List its various types.
Tell me how to debug the report?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
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?
Can we create tables in apps schema?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
List the types of flexfield?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
What is oracle soa suite?
do you know is it possible to run the interface without using oracle apps?
what is the differences between internal requisition and internal sales order?
what is global tempory table?
what is pay run id ?