PLSQL_Table_DataType1.htm |
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. |
Script:
|
|
Please review this article/example of using %TYPE proce_empcur1.htm |