Lists and queries
From: Marco Minerva <marco.minerva_at_libero.it>
Date: Sun, 04 May 2003 09:19:11 GMT
Message-ID: <jW4ta.88888$iy5.2756636_at_twister2.libero.it>
Hi All!
Date: Sun, 04 May 2003 09:19:11 GMT
Message-ID: <jW4ta.88888$iy5.2756636_at_twister2.libero.it>
Hi All!
I have a trouble with PL/SQL. I have a table like this:
TYPE Id_List IS TABLE OF NUMBER INDEX BY BINARY_INTEGER; EmptyId_List Id_List;
In a HTML form I have a multiselect combobox named Elements. The Submit button calls a PL/SQL procedure defined as follows:
procedure Check(Elements Id_List DEFAULT EmptyId_List)
I have to do a SELECT with a WHERE clause in which I must utilize all the values that are in Elements parameter. Something like this:
SELECT *
FROM MyTable
WHERE Code = (Any of the value in the Elements list);
How can I realized this type of query? Anyone can help me? Thanks to all in advance.
-- Marco Minerva, vbcorner_at_libero.it http://www.marcominerva.com/vbcornerReceived on Sun May 04 2003 - 11:19:11 CEST