How to store data in vArray and use in If Statement

From: sanjeev <sanjeev_atvankar_at_yahoo.co.in>
Date: 11 Mar 2007 22:24:14 -0700
Message-ID: <1173677054.126393.211120@c51g2000cwc.googlegroups.com>

Hi friends,

I have table called ANI_Master which stores codes

Please look at following query.

SELECT CALL_START_TIME,

              CALL_TYPE_ID,
              COUNT(CASE WHEN SUBSTR(ANI,1,8) IN


('+9198830','+9198831','+9198832') THEN  ANI END) AS RELIANCE,

              COUNT(CASE WHEN SUBSTR(ANI,1,8) NOT IN

('+9198830','+9198831','+9198832') AS NON_RELIANCE,
from callbycall
group by CALL_START_TIME;

In above case I need to use hardcoded values eg.
('+9198830','+9198831','+9198832') in CASE statement though there is
table ANI_master.
Is there any way to so that i can store the ANI values in array and use that array in IF statements.

Thanking in advance
Sanjeev Received on Mon Mar 12 2007 - 00:24:14 CDT