what is pl/sql table and pl/sql records? what is the use of
that?
- 3 Answers
- 9208 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
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
do you know is it possible to run the interface without using oracle apps?
how do you describe O2C along with tables
Is soa a part of oracle fusion middleware?
What do you understand by a set of books?
Tell me how to debug the report?
tell me the scenarios of the independent in reports
What is oracle soa suite?
what are the balancing segments in AR?
what are the different transaction clauses in AR?
What is sca and how is it useful?
Can you differentiate between mediator and osb?
What is the concept of soa governance?
Can we create tables in apps schema?
Tell me how to find the custom directory in front end?
