Record Data Type « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. Record Data Type
1.PL/SQL Collections: record type
2.The %ROWTYPE can also be used to create a record based on the structure of a cursor
3.A simple record that holds a person's name, phone number, and birth date and fill data in
4.Declare the record data type
5.Load a row in table to record type
6.A record is populated using a SELECT statement
7.declare record with not null attribute
8.Assign a wrong record type
9.This block shows legal and illegal record assignments.




10.How to select into a record.
11.Select into Records
12.Record type
13.Using explicit definition to define record types and a compound record type; and, the use of nested types
14.Nest records, access the names of the nested records by using another component selector, or period