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
- 32469 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 is choreography different from orchestration?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
What is a flexfield? List out its types.
How many schemas we have? how many you have used?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
Explain what are the tables of auto invoice?
what are the prerequisites for costing transactions?
Tell me how to debug the report?
What are the different components of soa suite?
what is global tempory table?
What are do's and dont's of Interface?
What is the concept of soa governance?
What is instead of trigger in where we will use?
Which oracle apps version you are very confident in?
