Answer Posted / a.v.bhaskar reddy
REF CURSOR is majorly used when we want to execute a
dynamic select statement causes to retrieve more than one
record. We can pass Ref cursor result as a out parameter
which can be used in other subprograms
| Is This Answer Correct ? | 28 Yes | 4 No |
Post New Answer View All Answers
Explain what are the tables of auto invoice?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
tell my any difficult situtation you solved in your experience in your company?
What is a flexfield? List out its types.
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
What is a value set? List its various types.
What are the Standard Reports and Forms in HRMS?
What does appl_top directory contain?
What is instead of trigger in where we will use?
In sequence i want to 11 and 15th values how we will write?
testing tools?
Do you know what are user profiles in apps. Any examples you can give?
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.
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?
