What is the result of this query ?
SELECT * FROM EMP WHERE ROWNUM = 1
- 25 Answers
- 26529 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 |
How to write the no data found in XML Publiser Report in apps?
what is aim methodolozy
wht r the basetables of customer interface?
I Have report which is having field at the end of page,,, problem is when i run report data is overflowing to the next page,,i want the data to come on same page can anybody help me out????
in procedure how to return a value
P_CONC_REQUEST_ID mandatory in oracle reports to run in oracle applications or not ( I am not talking about running in report builder or D2k ) or not ?
9 Answers CSC, IBM, KPIT, Oracle,
What are triggers?
what is the use of anchors?
how to find the custom directory in front end.
1 Answers IBM, Sierra Atlantica,
what is meant by lexical parameter
Is it possible calling from one report to another? if possible means tell me ?
3 Answers Intelligroup, Satyam,
Who information?s?
Oracle Apps Technical 
