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
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
What do you understand by a set of books?
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.
How to move the one file from one instance to another instance? And your scripts also?
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
How can we import the data into a database using sql * loader?
tell my any difficult situtation you solved in your experience in your company?
What is oracle soa suite?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
Can u give the Documentation of Custom.pll in oracle apps
What are do's and dont's of Interface?
What are file in oracle.
How many schemas we have? how many you have used?
what are the prerequisites for costing transactions?
Do you know what is applysys in oracle application database schema, what is apps?