Friday, December 29, 2017

PL/SQL - %TYPE and %ROWTYPE

  • %TYPE is used to declare a variable that is of the same type as a specified table’s column.
     
        example: Emp_number emp.empno%type;
  • %ROWTYPE is used to declare a record (the variable that represents the entire row of a table).
         example: Emp_record emp%rowtype;

No comments:

Post a Comment