|A PL/SQL record can contain different data types.
PL/SQL Table Data Type: Unlike a database table in Oracle , it contains/retrieves a single column. This data type allow creating an array of fields/ columns of a DATA BASE TABLE.
A PL/SQL table data type and a database table are two distinct objects exist in Oracle DBMS. A user defined %TYPE is more flexible than that of %ROWTYPE .
|The %ROWTYPE attribute handles pl/sql table-based as well as cursor based records. It simply suffice to sync identical to the structure of a specified table.|
|Please review this article/example of using %TYPE proce_empcur1.htm|