Explain the purpose of %TYPE AND %ROWTYPE data types?

%TYPE- The %TYPE lets you declare a constant, variable, collection element, etc as previously declared variable or column. It is an attribute which is used for anchoring. Example- the variable m_empno has same data type as the column empno in table emp.

%ROWTYPE- the %Rowtype attribute lets you declare a record that represents a row in the table.  The fields of the row have same name and data types as column in the view. Example- dept_rec dept%ROWTYPE . This declares a record that can store an entire row for DEPT table.