
1. Re: Extract X,Y from SDO_GEOMETRY / SDO POINT TYPE
Ying HuOracle Nov 25, 2013 8:32 AM (in response to 81355c9b6b5546c5ac58027b332478a9)If you have such point data in tab1(col1), you may have
select a.col1.sdo_point.x, a.col1.sdo_point.y from tab1 a;

2. Re: Extract X,Y from SDO_GEOMETRY / SDO POINT TYPE
user9221319 Jan 28, 2014 8:17 AM (in response to 81355c9b6b5546c5ac58027b332478a9)Assuming you have a table (geometry_table) with a geometry column (geometry) and an id column (id) the easiest way to get the x and y components is as follows:
select a.id, t.x, t.y from geometry_table a, table(sdo_util.getvertices(a.geometry)) t;
You want to make sure you use some unique identifier (or rowid) in your query to ensure that you can associate the correct components with each geometry in those cases where you have geometries with multiple points.
In your case, let's assume your geometry id = 1 and you only want the components for that id  your query would look like the following:
select a.id, t.x, t.y from geometry_table a, table(sdo_util.getvertices(a.geometry)) t where a.id = 1;
Your results would be as follows:
ID  X  Y

1 186858.487 481875.513
I also assumed that your geometry was actually:
SDO_GEOMETRY(2001, 90112, SDO_POINT_TYPE(186858.487, 481875.513, NULL), NULL, NULL)
and NOT as you typed above:
SDO_GEOMETRY(2001, 90112, SDO_POINT_TYPE(186858,487, 481875,513, NULL), NULL, NULL)
The second geometry is invalid (it would either have to be a 4D point  4001, or a 2D polyline  2002). See the following link for more details about the sdo_geometry type.
Spatial Data Types and Metadata
Enjoy!