Re: tables with binary_integer in PL/SQL

If you are using 7.3, Oracle has a feature to test the presence of a value in a pl/sql table.

Kjetil Skotheim <kjetil.skotheim_at_usit.uio.no> wrote in article <5ar4ae$ej1_at_ratatosk.uio.no>...
>
> How can I easily test if an entry in a table exists?
>
>
> The following does not work:
>
> declare
> type tt is table of number(10) index by binary_integer;
> brb tt;
> begin
> brb(1023):=234;
> if exist brb(1023) then begin
> logg(to_char(brb(1023))); end;
>
> end;
> /
>
>
>
>
> I could catch exceptions, but prefer to avoid that.
>
> Any ideas?
>
>
>
>
Received on Tue Jan 07 1997 - 00:00:00 CST