What is the result of this query ?
SELECT * FROM EMP WHERE ROWNUM = 1
Answer Posted / smruti
Guys,
Posting an answer is a nice effort, that means you are
trying to help other people overcome the trouble ahead.
But be cautious when posting an answer in public. Posting
wrong answers can be a sin.
Please be silent if you dont know atleast. After a damn
strong and correct answer from someone called Apps why u
people don't verify with urself. Archana don't show off
please.
SQL> SELECT * FROM EMP WHERE ROWNUM = 1;
EMPNO ENAME
---------- ----------------------------------------
1 SMRUTI
SQL> SELECT * FROM EMP WHERE ROWNUM = 22;
no rows selected
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
How to move the one file from one instance to another instance? And your scripts also?
Tell me how to debug the report?
What are do's and dont's of Interface?
What is a flexfield? List out its types.
Is soa a part of oracle fusion middleware?
How many schemas we have? how many you have used?
Do you know what is applysys in oracle application database schema, what is apps?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
A program must be written which accepts date parameter. The date parameter will accept data in the format DD/MM/YYYY. This data has to be validated and post validation, the following details have to be displayed for this date parameter 1. Input date must be defaulted to sysdate, It can be overridden by any other date. 2. Financial year should be displayed for this date parameter. Eg: If the input date is 30/11/2010, the financial year must be displayed as 1. From Date : 01-Aprr-2010 To Date: 31-Mar-2011 3. Calendar year and Calendar month must also be displayed. 4. The next payment cycle (say for EB), must be displayed based on this date parameter. 5. The previous payment must also be displayed based on this date.
What is oracle soa suite?
What does appl_top directory contain?
In support project one ticket alloted which steps follows manualy tell me ?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com