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
How many schemas we have? how many you have used?
what is pay run id ?
What are the different components of soa suite?
what are the balancing segments in AR?
Do you know what are user profiles in apps. Any examples you can give?
Can you explain the difference between architecture followed in 10g & 11g?
List the various types of value set.
In sequence i want to 11 and 15th values how we will write?
What are do's and dont's of Interface?
What do you understand by a set of books?
What is instead of trigger in where we will use?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
What are the Standard Reports and Forms in HRMS?
What is sca and how is it useful?
Can u give the Documentation of Custom.pll in oracle apps