How to calculate the point of intersection of 2 line geometries.
sdo_relate or sdo_intersection?
It has been a while since I have used spatial.
This might be a place to start.
otn spatial forum
We're looking for long answers that provide some explanation and context. Don't just give a one-line answer; explain why your answer is right, ideally with citations. Answers that don't include explanations may be removed.