I'd like to learn how to write PL/SQL spatial functions for use in an Oracle ST_GEOMETRY geodatabase. And I figure, the best way to learn something is to start with something that works, thoroughly study it, and then start writing my own functions from there.
So, I'd like to start with an existing SDE.ST_GEOMETRY function. How can I get the PL/SQL definition of SDE.ST_GEOMETRY functions, such as ST_NumPoints (or any other function for that matter)?
I've poked around the web looking for sample SQL for getting the source PL/SQL of functions. There's a lot of talk of packages, etc. and I'm just not really sure where to start.