Re: Help PL/SQL (Table Datatype.)
From: godzilla <brucep_at_intergate.bc.ca>
Date: Tue, 15 Sep 1998 06:19:29 -0700
Message-ID: <ulC$9sK49GA.91_at_upnetnews03>
>--
>Example from the book :
>
>DECLARE
> TYPE NumTabTyp IS TABLE OF NUMBER
>
> INDEX BY BINARY_INTEGER;
> sal_tab NumTabTyp;
>BEGIN
> /* Load salary table. */
> FOR i IN 1..50 LOOP
> sal_tab(i) := i;
> END LOOP;
> ...
> sal_tab := NULL; -- deletes sal_tab table <---- this line
does'nt
>work for me ???
>
>
>
>
>
Received on Tue Sep 15 1998 - 15:19:29 CEST
Date: Tue, 15 Sep 1998 06:19:29 -0700
Message-ID: <ulC$9sK49GA.91_at_upnetnews03>
Try this:
empty_tab NumTabTyp;
sal_tab := empty_tab
This should empty your sal_tab variable, provided you have not placed anything in empty_tab after declaring it.
Bruce
>--
>Example from the book :
>
>DECLARE
> TYPE NumTabTyp IS TABLE OF NUMBER
>
> INDEX BY BINARY_INTEGER;
> sal_tab NumTabTyp;
>BEGIN
> /* Load salary table. */
> FOR i IN 1..50 LOOP
> sal_tab(i) := i;
> END LOOP;
> ...
> sal_tab := NULL; -- deletes sal_tab table <---- this line
does'nt
>work for me ???
>
>
>
>
>
Received on Tue Sep 15 1998 - 15:19:29 CEST