Anchored Declaration is used to set the datatype of your variable based on the datatype of an already defined variable or a column of a table.
PL/SQL offers two kinds of anchoring:
Scalar anchoring :- Use the %TYPE attribute to define your variable based on a table's column or an already declared PL/SQL scalar variable.
Record anchoring :- Use the %ROWTYPE attribute to define your record structure based on a table or a predefined PL/SQL explicit cursor.
No comments:
Post a Comment