Question: what is the difference between type and rowtype in pl sql?
Answer: Difference Between %TYPE and %ROWTYPE. %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.