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
- 10131 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
What are the Standard Reports and Forms in HRMS?
What is oracle soa suite and what are its different components?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
In hierarchical structure of a database? we have write query from where we should start?
What is count(*) from po_vendors(any table)?
List the types of flexfield?
What does appl_top directory contain?
Can you define an erp system?
what are the different transaction clauses in AR?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in
What are the benefits of using soa architecture?
How is choreography different from orchestration?
Can we create tables in apps schema?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
