Re: PL/SQL Help Request: Collections of Records

mblackwell264 wrote:

> 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

http://www.psoug.org/reference/type.html

Please do not post your messages to every usenet group you can spell. Pick the one most appropriate and post to just the one.

Thank you.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)