What is the result of this query ?
SELECT * FROM EMP WHERE ROWNUM = 1
- 25 Answers
- 26534 Views
- IBM, Satyam, I also Faced
- E-Mail Answers
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 many schemas we have? how many you have used?
what is pay run id ?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
What are file in oracle.
do you know is it possible to run the interface without using oracle apps?
Is soa a part of oracle fusion middleware?
In support project one ticket alloted which steps follows manualy tell me ?
can we use look up type instead of a pofile option?or valueset?is it possible how?
How can you achieve loose coupling in soa framework?
Tell me where we find the status of order information?
How can a process be deployed in soa?
Explain what are the tables of auto invoice?
Explain oracle apps architecture.
What are do's and dont's of Interface?
Can we create tables in apps schema?
