oracle written user functions

I needed to write a simple Oracle PL/SQL function today.

This example came in handy.

The difference between a PL/SQL function and a PL/SQL procedure is that a function returns a single value, and a procedure doesn't return any values.

However, a procedure can modify parameters (and I think a function can too), so even if you don't return any values, you can get information back to the caller.