What is the result of this query ?
SELECT * FROM EMP WHERE ROWNUM = 1
Answer Posted / rao
SELECT * FROM EMP WHERE ROWNUM = 1
it will be returned only one record. we have to display the
more than records using below mentioned statement....
SELECT * FROM EMP WHERE ROWNUM < 4...
Answer is correct ... checked also
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is oracle soa suite and what are its different components?
tell me the scenarios of the independent in reports
can we use look up type instead of a pofile option?or valueset?is it possible how?
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
what is global tempory table?
tell me the scenarios of the independent in reports
please send me forms, xml pulisher questions,answers
Tell me how to debug the report?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
What do you understand by soa?
List the types of flexfield?
how do you describe O2C along with tables
In hierarchical structure of a database? we have write query from where we should start?
Do you know what are user profiles in apps. Any examples you can give?
Tell me how to find the custom directory in front end?