What is the result of this query ?
SELECT * FROM EMP WHERE ROWNUM = 1
Answer Posted / apps
ROWNUM is generally used in >=, <=, <, >. But there is
exception, you can use it = also but only with 1 as
ROWNUM=1, it will display first record in table. If you use
ROWNUM=10…. Or any number other than 1 then it will not
display any records.
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
How to move the one file from one instance to another instance? And your scripts also?
please send me forms, xml pulisher questions,answers
q)what are the validations in sql*loader
tell me the scenarios of the independent in reports
what is global tempory table?
What does appl_top directory contain?
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.
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in
What are the Standard Reports and Forms in HRMS?
Do you know where we can check the status of po?
What is sca and how is it useful?
What is the concept of soa governance?
tell me the scenarios of the independent in reports
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
How can you achieve loose coupling in soa framework?