Thursday, 24 May 2012

Can you define a record type based on an explicit cursor? | PL SQL

  Yes, It is possible to define a record type based on the selected columns of an explicit cursor. This helps in retrieving the entire row together into the defined record and further processing. The values of the row are directly loaded into the fields of the record.