Example for simple Oracle PL/SQL package: http://www.sqlfiddle.com/#!4/9bbe9/2
It took me a while to figure out how to set up the query terminator and semi-colons and where to put the package code, so hopefully someone else finds this handy.
I like it! That's now the sample for oracle. Feel free to come up with other clever fiddles and I'll happily consider making them the sample for the others. Thanks
Example for simple Oracle PL/SQL package: http://www.sqlfiddle.com/#!4/9bbe9/2 It took me a while to figure out how to set up the query terminator and semi-colons and where to put the package code, so hopefully someone else finds this handy.