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
What are the Standard Reports and Forms in HRMS?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
What is count(*) from po_vendors(any table)?
What is oracle soa suite?
tell me the scenarios of the independent in reports
Can you explain the difference between architecture followed in 10g & 11g?
Do you know where we can check the status of po?
What are the different components you should consider while defining a responsibility in oracle apps?
Tell me how to find the custom directory in front end?
what are the balancing segments in AR?
What is oracle soa suite and what are its different components?
tell my any difficult situtation you solved in your experience in your company?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
can we get profile values in report without using user exists is it possible how?
What are the benefits of using soa architecture?