PL/SQL Collections: record type : Record Data Type « PL SQL « Oracle PL / SQL






PL/SQL Collections: record type

  
SQL>
SQL> Set serverout on
SQL> declare
  2    type location_record_type is record (
  3      street_address       varchar2(40),
  4      postal_code          varchar2(12),
  5      city                 varchar2(30),
  6      state_province       varchar2(25),
  7      country_id           char(2) not null := 'US'
  8    );
  9
 10    l_my_loc location_record_type;
 11  begin
 12    l_my_loc.street_address  := '1 Way';
 13    l_my_loc.postal_code     := '22222';
 14    l_my_loc.city            := 'ABC';
 15    l_my_loc.state_province := 'VA';
 16    dbms_output.put_line( 'MY LOCATION IS:' );
 17    dbms_output.put_line( l_my_loc.street_address );
 18    dbms_output.put( l_my_loc.city||', '||l_my_loc.state_province );
 19    dbms_output.put_line( ' '||l_my_loc.postal_code );
 20    dbms_output.put_line( l_my_loc.country_id );
 21  end;
 22  /
MY LOCATION IS:
1 Way
ABC, VA 22222
US

PL/SQL procedure successfully completed.

SQL>
SQL>

   
  








Related examples in the same category

1.The %ROWTYPE can also be used to create a record based on the structure of a cursor
2.A simple record that holds a person's name, phone number, and birth date and fill data in
3.Declare the record data type
4.Load a row in table to record type
5.A record is populated using a SELECT statement
6.declare record with not null attribute
7.Assign a wrong record type
8.This block shows legal and illegal record assignments.
9.How to select into a record.
10.Select into Records
11.Record type
12.Using explicit definition to define record types and a compound record type; and, the use of nested types
13.Nest records, access the names of the nested records by using another component selector, or period