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 :

  • Need not know about variable's data type
  • 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 :


Discussion

No Comment Found

Related InterviewSolutions