|
Re: Assign multiple values to variables [message #549507 is a reply to message #549506] |
Sat, 31 March 2012 08:19 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Varying elements in IN list on AskTom might be what you are looking for.
If you read the whole discussion, you'll probably find a global temporary table (GTT) solution of the problem, i.e. you'd insert these values into a GTT and use it in your WHERE clause as
-- insert some records into a GTT
insert into gtt (id) values (1);
-- or possibly
insert into gtt (id) values (:form_block.some_item);
...
-- now use them in WHERE clause:
select ...
from some_table
where id in (select id from gtt)
and ...
|
|
|