Thursday, June 30, 2011

Records in PL/SQL

What is record in PL/SQL ?
A record is a composite data structure i.e. it consists of elements. A record by itself does not have value, but the elements in it will be having values. We can compare a record in PL/SQL with that of the table.

Various Methods to declare records :
  1. Table based declaration.
  2. Cursor based declaration.
  3. Programmer defined records.
PS: Pseudo records in trigger are :NEW and :OLD

No comments:

Post a Comment