Does anyone know how the SDO_WITHIN_DISTANCE works with featureclasses that are unprojected i.e. just Geographic WGS 84 systems. As I don't see how the km/miles units can work unless it does an on the fly calculation to calculate the degree distance to km/miles.
This is born from trying to use ST_DISTANCE (ESRI way) to calculate distance between two features and there is no way to specify measurement units, it just gives you back a degree distance, which is fair enough.
Further to this - does anyone know of a spatial function comparison matrix - so you can see the equivalent function of what the Oracle command is versus the command using ST_GEOMETRY? I think that would be very useful.