Use of % TYPE and % ROWTYPE in ORACLE, % type % rowtype

Use of % TYPE and % ROWTYPE in ORACLE, % type % rowtype

% TYPE is used in the declaration of variables to obtain the field TYPE in the table;

% ROWTYPE is used to declare the row type based on a table;
 

Example:

% ROWTYPE

DECLARE
CURSOR pdct_cur
Is select * from productinfo;

Cur_prodcrd productinfo % ROWTYPE;

BEGIN
OPEN pdct_cur;
FETCH pdct_cur INTO cur_prodrcd;
DBMS_OUTPUT_PUTLINE (cur_prodrcd.productid | '-' | cur_prodrcd.productname );
CLOSE pdct_cur;
END;

% TYPE usage

DECLARE
Cur_productid varchar (10 );
Cur_prodctname productinfo. productname % TYPE;

CURSOR pdct_cur
Is select productid, productname from productinfo;


BEGIN
OPEN pdct_cur;
FETCH pdct_cur INTO cur_productid, cur_productname;
DBMS_OUTPUT_PUTLINE (productid | '-' | productname );
CLOSE pdct_cur;
END;

 

Http://leettest.com