1 Reply Latest reply on Oct 29, 2012 7:42 AM by 922439

    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 ??