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
- 32467 Views
- IBM, Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / archana patil
It won't display any record. It return with zero or no records.
| Is This Answer Correct ? | 0 Yes | 6 No |
Answer / vishnu pratap mall
it will display all records of the employee of the first row
in the table.
| Is This Answer Correct ? | 2 Yes | 9 No |
Answer / prakash
it will gives result:no rows returned.
because rownum applicable onle < or <=
not use > or >=.
| Is This Answer Correct ? | 13 Yes | 24 No |
Difference between set of books id and ledger id in r12 ?
What is the difference between buyer&employee in PO module?
Can you differentiate between mediator and osb?
what is the difference between po_vendors & po_headers_all? does po_vendors relate to opeating unit?
What is multi org?
we have 10 records. It's occured error in 6th record how can u find and how to rectify that?
How to create user and how u attach with responsibility.
testing tools?
0 Answers BirlaSoft, Convergys,
What are the Import Programs We need to run after creating Interface table for all modules
why do we validate the records while developing interface?
Who information?s?
What is ment by Global Templates in Oracle.
Oracle Apps Technical 
