InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Are % Type And % Rowtype? What Are The Advantages Of Using These Over Datatypes? |
|
Answer» % TYPE provides the DATA type of a VARIABLE or a database column to that variable. % ROWTYPE provides the record type that represents a entire row of a table or view or columns selected in the CURSOR. The ADVANTAGES are : I. Need not know about variable's data type ii. If the database definition of a column in a table changes, the data type of a variable changes accordingly. % TYPE provides the data type of a variable or a database column to that variable. % ROWTYPE provides the record type that represents a entire row of a table or view or columns selected in the cursor. The advantages are : I. Need not know about variable's data type ii. If the database definition of a column in a table changes, the data type of a variable changes accordingly. |
|