what is pl/sql table and pl/sql records? what is the use of
that?
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
tell me the scenarios of the independent in reports
What are the different components you should consider while defining a responsibility in oracle apps?
what are the balancing segments in AR?
Can you differentiate between mediator and osb?
List the types of flexfield?
In support project one ticket alloted which steps follows manualy tell me ?
Do you know what are user profiles in apps. Any examples you can give?
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 does appl_top directory contain?
Explain oracle apps architecture.
what is the difference between request group and request security in oracle apps?
What are the benefits of using soa architecture?
Do you know what is applysys in oracle application database schema, what is apps?
tell me the scenarios of the independent in reports