2 Replies Latest reply: Nov 24, 2012 4:53 PM by Johan Louwers RSS

    Distance Calculation between two points

    685580
      Hi....
      can anybody help me out how to find the distance between two points (x1,y1) and (x2,y2)

      Thanks and Regards,
      Kiran Kumar
        • 1. Re: Distance Calculation between two points
          sujnan
          Hi,

          If you looking oracle spatial solution refer this link.
          [http://download.oracle.com/docs/html/A85337_01/sdo_objg.htm#857959]

          SELECT SDO_GEOM.SDO_DISTANCE(c_b.shape, m.diminfo, c_d.shape, m.diminfo)
          FROM cola_markets c_b, cola_markets c_d, user_sdo_geom_metadata m
          WHERE m.table_name = 'COLA_MARKETS' AND m.column_name = 'SHAPE'
          AND c_b.name = 'cola_b' AND c_d.name = 'cola_d';


          If you looking for spatial formula refer this or google it for 'distance formula'
          [http://math.about.com/library/bldistance.htm]


          Sujnan
          • 2. Re: Distance Calculation between two points
            Johan Louwers
            Hi,
            you can have a look at this page where you can find some examples on how you can do this without the need for spatial

            http://hoopercharles.wordpress.com/2011/06/13/calculate-the-distance-between-two-latitudelongitude-points-using-plain-sql/

            Regards,
            Johan Louwers.