The SDO_GEOMETRY object has these attributes:
SDO_GTYPE NUMBER,
SDO_SRID NUMBER,
SDO_POINT SDO_POINT_TYPE,
SDO_ELEM_INFO SDO_ELEM_INFO_ARRAY,
SDO_ORDINATES SDO_ORDINATE_ARRAY
Question: Can both the SDO_POINT attribute and SDO_ELEM_INFO/SDO_ORDINATES be populated in the same geometry?
For example, SDO_GEOMETRY(2002, NULL, SDO_POINT_TYPE(-79, 37, NULL), SDO_ELEM_INFO_ARRAY(1, 2, 1), SDO_ORDINATE_ARRAY(1, 2, 3, 4))
Or is it always either one or the other?
SDO_GEOMETRY(2002, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1), SDO_ORDINATE_ARRAY(1, 2, 3, 4))
—or—
SDO_GEOMETRY(2001, NULL, SDO_POINT_TYPE(-79, 37, NULL), NULL, NULL)
Thanks.