DEVFYI - Developer Resource - FYI

What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?

ORACLE Interview Questions and Answers (Part 3)


(Continued from previous question...)

502. What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?

% 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.

(Continued on next question...)

Other Interview Questions