Query a VARRAY
From: Juerg <juerg.schaufelberger_at_tele2.ch>
Date: Fri, 2 Sep 2011 03:27:42 -0700 (PDT)
Message-ID: <4d0573a3-9215-411e-8fab-63077519397c_at_hb5g2000vbb.googlegroups.com>
Hello,
I like to query the SDO_ELEM_INFO of a SDO_GEOMETRY column like that:
Date: Fri, 2 Sep 2011 03:27:42 -0700 (PDT)
Message-ID: <4d0573a3-9215-411e-8fab-63077519397c_at_hb5g2000vbb.googlegroups.com>
Hello,
I like to query the SDO_ELEM_INFO of a SDO_GEOMETRY column like that:
select distinct p.geometry.sdo_elem_info from pointtable p;
Why does it not work? What's wrong?
Thanks in advance
Received on Fri Sep 02 2011 - 05:27:42 CDT