What is the difference between rowtype and type
%TYPE is used to get type of a variable or a table column.
%ROWTYPE is used to obtain the type of line of a cursor or table.
CURSOR c is SELECT id, name, type, email
WHERE type = 'CORPORATE';
FETCH c INTO cust_rec;
EXIT WHEN c%NOTFOUND;
DBMS_OUTPUT.PUT_LINE('Customer name: '||cust_rec.name||' '||cust_rec.email);