1 Reply Latest reply: Oct 29, 2012 2:42 AM by 922439 RSS

    fetchind co-ordinates from sdo_geometry object

      I have the following table structure :
      create table buildings
      bid varchar(5) primary key,
      bname varchar2(50),
      points integer,
      shape sdo_geometry

      now using jdbc if I want to extract each co-ordinate, how will i use select query as to get proper resultset ? as doing select * from buildings returns me the whole object shape. then how do i access values inside it ??