Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Set operations on VARRAY

511510Nov 24 2008 — edited Jan 8 2009
Using 10g

I have an array
defined as VARRAY(15) or number(1);

and I store 0 or 1 as part of the algorthm. I then need to determine if there is at least one
0 in the varray. I could do this with a loop (of course) but I have tried using
if 1 in (arr) then

But that gave a compiler error. I think I need to cast it into a TABLE. But I can't manage
to do that.

How is this done?

CSS
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 5 2009
Added on Nov 24 2008
11 comments
955 views