JaySan

• Dec 28th, 2006

 

1.what is difference between pl/sql table ...

Ans. PL/SQL table is not created permanently in the database and it's only for the session, once the program is complete the table is no longer available so it's used generally when you have some bulk data to store but not permanently.

2. What is the advantages of PL/SQL Tables?

Ans. The performance is faster access/retreival of data is faster and it's not permanent as well.

thanks

jaysan

ranjeetapegu

 Profile Answers by ranjeetapegu Questions by ranjeetapegu

• Jan 12th, 2007

 

Difference between Pl/sql tables and record is that in pl/sql tables we can store more than one row

whereas in record we store only one row.

TYPE rec_emp is RECORD( ename   varchar2(10), empno number (5));

rec_emp1 rec_emp

Whereas a pl/sql  Table is

TYPE tab_emp is TABLE OF rec_emp index by binary_integer;

T_emp tab_emp;

srini

• Feb 6th, 2007

 

Actually explicit cursor refers only one work area in memory,incase of ref cursor refers different work areas in memory.