Small Oracle % type and % rowtype instances

// % Type
// If the declared variable is directly mapped to a column in the database, you can use the % type keyword to map the variable
// Pin the column. What are the benefits of doing so?
// For example:
// Declare v_ename scott. emp. ename % type;
// This method is flexible when the data type changes.
// If the length of a column is changed, the length of all variables anchored to the column is automatically changed;
// If we define v_ename as varchar2 (10), when the ename column in the emp table changes,
// We need to manually change v_enam to the same data length as emp. ename;
// When we use the anchor type, the variable is automatically adjusted.
// % Rowtype
// % Rowtype is similar to % type. However, it mounts the variable to all columns of the table, rather than to a column;
//