SDO_GEOM.SDO_INTERSECTION between a line and a polygon returns what?
Someone answered this question for me and it is as I suspected.
SDO_INTERSECTION will return any lines fully contained within a polygon, as well as those parts of intersecting lines, which are within the polygon.
In other words, it will return the geometry of everything in red in the example image.