Re: PL/SQL Tables (i.e. "arrays") Question?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 6 Mar 2000 21:00:09 -0000
Message-ID: <952376533.13297.0.nnrp-11.9e984b29@news.demon.co.uk>

If you are running Oracle 8, then you can declare a VARRAY or TABLE type.
This can then be used as if it were a
table using CAST() and THE() (8.0)
or TABLE() (8.1)

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Sean_at_kewi.net wrote in message <8a15f9$a8v$1_at_nnrp1.deja.com>...
>I have a PL/SQL of VARCHAR2 type that stores a list of words. I would
>like to be able to use this table like any other table in Oracle -
>mostly to do a NOT IN statement compared to another table.
>
>Are PL/SQL tables searchable and usable like other tables?
>
>If not, any ideas how to filter out data in the PL/SQL tables when
>compared to another table without having to for loop... through
>table.count?
>
Received on Mon Mar 06 2000 - 15:00:09 CST