Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> PL/SQL Help Request: Collections of Records

PL/SQL Help Request: Collections of Records

From: mblackwell264 <mblackwell264_at_cox.net>
Date: Sun, 21 Mar 2004 14:26:45 -0500
Message-ID: <10m7c.12909$1e1.6562@lakeread06>


Platform:

     Oracle9i (9.2)

Data structures:

     TYPE mtyp_data_rec IS RECORD (
        field1   varchar2(10),
        field2   varchar2(13),
        field3   varchar2(11)
        ) ;

     TYPE mtyp_values_tab IS TABLE OF mtyp_data_rec ;

     ltbl_work_table     mtyp_values_tab := mtyp_values_tab() ;


Question:

     Could someone please give me an example of how to properly reference a field from this table of records?

Thank you.

--Michael

   mblackwell_at_acm.org Received on Sun Mar 21 2004 - 13:26:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US