Oracle Technology Network(OTN) is a great source for information, downloads, events, ... for me, just like Time explains in his OTN appreciation day blog post.
So here is my feature I like in Oracle: Functions returning record structures.
It's not the biggest cool thing, but something I use a lot.
A PL/SQL function has only one RETURN parameter, but what when you have to return multiple values?
I've seen people using OUT parameters in a function. But when I see that, I start shivering.
To me, there's only one way out for values in function... the RETURN clause(and one of Steven Feuerstein's best practices).
When you need to return multiple values, use a record structure!
And a cool feature in Oracle functions is, that you can access fields directly from the record in your function call.
You can retrieve the last name like this:
Pretty cool, isn't it?