Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Lists and queries
You want to use in not = . Look at the asktom.oracle.com and do a search
there.
Jim
-- Replace part of the email address: kennedy-down_with_spammers_at_attbi.com with family. Remove the negative part, keep the minus sign. You can figure it out. "Marco Minerva" <marco.minerva_at_libero.it> wrote in message news:FU4ta.89811$DT4.2758899_at_twister1.libero.it...Received on Sun May 04 2003 - 10:47:49 CDT
> 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/vbcorner
>
>