What is the result of this query ?
SELECT * FROM EMP WHERE ROWNUM = 1
- 25 Answers
- 26647 Views
- IBM, Satyam, I also Faced
- E-Mail Answers
Answer Posted / pulakesh dey
It will not display any record. Rownum is a pseudo column.
This column only will be populated once the result set is
generated. That is the reason if you write a same query in
ascending or descending order the rownum of a specific
record will be different.
| Is This Answer Correct ? | 8 Yes | 13 No |
Post New Answer View All Answers
how to print multi lay outs,muti currency,muti language in xml publisher
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
what are the different transaction clauses in AR?
Explain oracle apps architecture.
Is soa a part of oracle fusion middleware?
What are the different components you should consider while defining a responsibility in oracle apps?
Are you familiar with internet architecture of oracle apps 11i?
What do you understand by a set of books?
Do you know where we can check the status of po?
What are do's and dont's of Interface?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
Can you explain the difference between architecture followed in 10g & 11g?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
what is global tempory table?
Tell me where we find the status of order information?
