PL/SQL table in select statement

From: Andreas Will <Andreas.Will_at_gmx.de>
Date: 2000/06/28
Message-ID: <8jd7jc$fk5$1@nnrp1.deja.com>#1/1

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. Received on Wed Jun 28 2000 - 00:00:00 CDT