Re: "IS TABLE OF" help

From: William Robertson <william.robertson_at_bigfoot.com>
Date: 26 Jul 2005 11:01:44 -0700
Message-ID: <1122399900.111210.253640@g14g2000cwa.googlegroups.com>

soup_or_power_at_yahoo.com wrote:
> Can someone please explain what these two statements in a PL/SQL block
> mean? Thanks for your help
>
> TYPE plist_id_tab IS TABLE OF tmp_profile_tbl.plist_id%TYPE;
> plist_id_tbl plist_id_tab := plist_id_tab();

It declares a collection type. plist_id_tbl will be a collection (array).
http://download-uk.oracle.com/docs/cd/B10501_01/appdev.920/a96624/05_colls.htm#19666 Received on Tue Jul 26 2005 - 13:01:44 CDT