Today's Oracle gem of the day is the fact that later versions of Oracle support pipelining functions to return rows of a table as soon as they are available! I've always wanted something like this. I wouldn't be surprised if someone said it was going into Perl 6 but it went over my head at the time.
A smaller gem is the fact that you can put DETERMINISTIC on a function to memoize it.
