Re: Emptying a PL/SQL TABLE
From: Mitro Kivinen <nbs-mki_at_nbs.fi>
Date: 1996/07/30
Message-ID: <31FDAD92.671_at_nbs.fi>#1/1
Date: 1996/07/30
Message-ID: <31FDAD92.671_at_nbs.fi>#1/1
mlanda_at_vnet.ibm.com wrote:
> >> However, you can use a simple workaround to delete an entire
> >> PL/SQL table. Simply assign NULL to it, as shown in the following
> >> example:Do so:
Define two similar tables:
tab_1 and tab_2
Use tab_1 as the working table and tab_2 as the NULL -table. When you need to empty the frist, just assing the second onto it!
tab_1 := tab_2;
Mitro Received on Tue Jul 30 1996 - 00:00:00 CEST