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
- 33490 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 |
differentiate between intra & inter UOM class conversion with examples.
what is the purpose of standard cost update?
In which directory your flatfile is given?if u connected different instance where it is find?
where the accounting related data is stored ?
what is multi org structure?
What do you understand by a set of books?
what are the tables of auto invoice.
what is meant by bind parameter?
what is the prerequisite for defining unit of measure?
what is pl/sql table and pl/sql records? what is the use of that?
in sql loader,i have 100 records in my flatefile, i want to skip the 80 to 90 records .please help me
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
Oracle Apps Technical 
