What is the result of this query ?
SELECT * FROM EMP WHERE ROWNUM = 1
- 25 Answers
- 26316 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 |
What are profile options?
Tell me some thing about SQL-LOADER.
in procedure how to return a value
what is pl/sql table and pl/sql records? what is the use of that?
Tell me how to find the custom directory in front end?
What do you understand by soa?
what are centralized and decentralized level of control of item attributes?
How many parameters we can pass through pl/sql program in Oracle apps
please send me forms, xml pulisher questions,answers
Assume i have three Procedures defined in a Package Spec. I have created the Package Specification. now i create the Package Body by including the three procedures in addition to that i include a fourth procedure which is not included in my Package Spec. I compile the Package Body. Will the Package body Compile ? What will the end result ? what will happen if the execute the package by calling the 4th procedure ?
what are the difference between 11.5.7 and 11.5.9 in oracle apps
How many phases of implementation and what are those.
Oracle Apps Technical 
