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>

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

Original text of this message