Re: PL/SQL table in select statement

Andreas Will wrote:
>
> Hi,
>
> can I use a PL/SQL table in a where clause of a select statement? Or how
> can I transform it?
> e.g.:
>
> *************************************************
> TYPE number_tabletype IS
> TABLE OF NUMBER INDEX BY BINARY_INTEGER;
>
> fid_plsql_table number_tabletype;
>
> fid_plsql_table(1) = 123;
> fid_plsql_table(2) = 456;
> [...]
>
> CURSOR fid_cursor IS
> SELECT * FROM fid_table
> WHERE fid IN fid_plsql_table
> [...]
> *************************************************
>
> tnx, Andreas
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

This may help...

http://www.jlcomp.demon.co.uk/v7arrays.html

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse