Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

PLSQL allows you to use the %type attribute in a nesting variable declaration

dept_sales    INTEGER; area_sales    dept_sales%type; group_sales     area_sales%type; regional_sales  area_sales%type; corporate_sales  regional_sales%type;