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

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;