What is the result of this query ?
SELECT * FROM EMP WHERE ROWNUM = 1
- 25 Answers
- 26448 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 the prerequisites for costing transactions?
After completing Report customization process.suppose we have 10 report parameter in report so, that we re-register that parameter in concurrent program?
what is meant by Drill Down in Discoverer report? why it will be use?
Where I can download D2K software?
In custom.pll what are the events we can Not write.
Is it is necessary to create P_CONC_REQUEST_ID parameter in the development of oracle apps reports
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 ?
while registering executable and concurent program we register both with application name|<oracle purchasing>? so my question is why we are defining in both concurent program and executable?
After deploying like forms,reports into server how we connect this forms,reports to web?
What is the interface?
how to avoid duplicate data while uploading data from flatfile to staging table? some validations
What are the benefits of using soa architecture?
Oracle Apps Technical 
