Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> OCI, host arrays and where clause
Is it possible to use arrays in OCI in the where clause of a select statement? Consider the following:
...
const char fooArr[2][4]= { "one", "two" };
const char *stmt=
"select foo, bar from blah where foo = :fooArr"
...
When executed the statement should be equivilent to
select foo,bar from blah where foo = 'one'
union
select foo,bar from blah where foo = 'two'
-- Kelly R. Burkhart nospam mailto kburk at sky dot netReceived on Sat Jan 10 1998 - 00:00:00 CST