Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Using VARRAY in "IN" clause
Does anyone know how to do what I'm trying to illustrate in the following
"make believe" SQL statement? I want to use an array as the variable in the
"IN" clause.
declare
TYPE x_type IS VARRAY(10) OF INTEGER;
x x_type := x_type(1,2,3,4);
begin
select the_name
from name_table where name_id in (x);
Thank you,
Chad Sheley
Senior Consultant
Cap Gemini
Des Moines, IA
Received on Tue Nov 16 1999 - 12:11:17 CST