Database Software

Can anyone possibly advise me how to correctly query a spatial point feature and return the angle of orientation?

I can use the following to return certain information but can not find any information on how to get at the angle of orientation.

SELECT a.ID, a.geometry1, sdo_util.EXTRACT (a.geometry1, 1)
FROM dfaiveg.gf_label a;

SELECT a.ID, a.geometry1, t.x, t.y
FROM dfaiveg.gf_label a, TABLE (sdo_util.getvertices (a.geometry1)) t;

These return the coordinates of the point geometry.

I would like to test the angle of orientation in a trigger or pl/sql and then correct the angle of orientation if it is meets certain criteria.

I am using Ora 9i (but could use Ora 10g if I had to - installation is not fully implemented)

Regards Adrian