Re: VARRAYs in Oracle 8.0.3

Hi,

Could someone please tell me if the new 'THE' operator is supported for VARRAYs ? It doesn't seem to be supported in 8.0.3 but is it supported in 8.0.4 ? Are there any operators that work on individual elements of VARRAYs in SQL*PLUS (please specify the Oracle version which supports the same).

Also, do the Oracle JDBC thin drivers support the object features ?

Thanks,

Gunjeet

In article 1_at_corpnews1.Corp.Sun.COM, gunjeet_at_sunsparkle.corp.sun.com (Gunjeet Singh) writes:
> Hi,
>
> I have a requirement of creating a table where for a given id, i have
> to either store three cost components (for a given qtr), or store 4
> sets of such components (4 * 3 for a year). I'm looking at the
> possiblity of designing this table with a VARRAY column where each of
> the elements of VARRAY will store three cost components and the size of
> the VARRAY will be 4.
>
> Is it possible to directly do a select against such a table and select
> the cost component values in such a form that it can be directly used
> by the front end - or will I be forced to use PL/SQL to parse the
> output of a select against this table to extract the values ?
>
> ------------- Example deleted --------------
>
> Any examples will he very helpful.
>
> Thanks,
>
> Gunjeet
>
Received on Mon Sep 21 1998 - 00:00:00 CDT