Interested to Buy Any Domain ? << Click Here >> for more details...
what is pl/sql table and pl/sql records? what is the use of
that?
- 3 Answers
- 10093 Views
- Intelligroup, I also Faced
- E-Mail Answers
Answer Posted / vans
The usage of plsql table and plsql records is high
performance.It enhance the performance.
Rather than using the cursor variable we can make use of
plsql records which is less time consuming.
For ex:
CURSOR emp_cur IS
SELECT trunc(sysdate) AS hire_date
,202 AS business_group_id
,'Raz' AS last_name
,'M' AS SEX
,13 AS person_type_id
,'Test Employee Creation3' AS per_comments
from dual;
TYPE tab_emp IS TABLE OF emp_cur%rowtype INDEX BY
BINARY_INTEGER;
emp_rec tab_emp;
The rest of the information is being provided by Srinivasa
Reddy
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
List the types of flexfield?
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
What is the concept of soa governance?
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
Do you know what are user profiles in apps. Any examples you can give?
What is a value set? List its various types.
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.
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
Explain what are the tables of auto invoice?
How to create a purchase order without a requisition?
What does appl_top directory contain?
Do you know what is applysys in oracle application database schema, what is apps?
List the various types of value set.
What are the Standard Reports and Forms in HRMS?
what is the difference between request group and request security in oracle apps?
