Query a VARRAY
From: Juerg <juerg.schaufelberger_at_tele2.ch>
Date: Fri, 2 Sep 2011 03:22:09 -0700 (PDT)
Message-ID: <76cfb6b6-4024-42f5-aa02-689c41058206_at_o9g2000vbo.googlegroups.com>
Hello,
I like to query the SDO_ELEM_INFO of a SDO_GEOMETRY column like that:
Date: Fri, 2 Sep 2011 03:22:09 -0700 (PDT)
Message-ID: <76cfb6b6-4024-42f5-aa02-689c41058206_at_o9g2000vbo.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:22:09 CDT