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
- 33454 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 |
Explain oracle apps architecture.
What do you understand by a set of books?
what is user exit and wat program do we write in user exit?
1. when we r doing interface/conversion which things u will take care to improve the perfrmonce?(except bulk collect) 2. In conversion,u r loading the data using sql*loader,I dnt want to use sql*loader,& i have millions of records,Id der any way to load the data withing fraction of time considering best performance. 3. When u r doing conversion,taht using sql*loader u r loading data into staging table,u r writing control file bt I dnt want to use sql*loader,when u r creating con prog that time can we pass all values from flat file using paramere,valuset?how? 4. In flat file u got 50 records,out of 50 ,30 records are proceesed & inserted into base table,after taht clien understood that 1 item having wrong name e.g insted of ABC he given DCE, so can we delete?hw?(client permission is der) i have lot of wrong item name randomly spreaded,can we delete it?hw? 5.after doing validation hw u will follow approach to error out records?if i want to send all the error out records to client daily,whats ur approach? 6. In outbound interface is der any way to load the data(large data-millions of records) except UTL_FILE package? 7. what is parsing? 8. In technical doc.s which section will mention?except code? 9. Do u have any idea about code depository tool? 10.whats is performance tunning,DB link? 11, How u will do RMA?
How will u register concurrent request ?
In hierarchical structure of a database? we have write query from where we should start?
Difference between triggers and procedures?
What is the Exception. Types of exception, Difference between those. And example
Attribute data types?
In sequence i want to 11 and 15th values how we will write?
How to report output like below supplier name date amount abc software jan/11 10000 /* jan month total transactions*/ abc software feb/12 30000 /* feb month total transactions*/ dell computers jan/13 45000 /* jan month total transactions*/
what are the default arguments for pl/sql program?
Oracle Apps Technical 
