Archive for September, 2007

Functions as default values…

Friday, September 21st, 2007

If you have a program with parameters that have default values and you want the user to be able to change the default values of the parameters, without you having to change the value in the code, then put that data in a table.
Why shouldn’t you just retrieve the data from the table in the [...]

Using inline views to achieve SPOD

Sunday, September 9th, 2007

If you are wondering what SPOD is, then check out this blog post by Steven Feuerstein. Suppose you want to create a SQL statement (for a view or cursor or something else) where you want the value of one mathematical function to be used as input for another mathematical function. For simplicity reasons I am just using some [...]

How old…

Saturday, September 8th, 2007

…must you be to start with Oracle? Here are a couple of pictures of my 4-year old son Mitchell.
I think this really is too young, but he seemed to enjoy the Oracle hat.

Dutch Toad Usergroup…

Thursday, September 6th, 2007

On november 16th the Dutch Toad Usergroup will be holding a free seminar at the Amsterdam ArenA. If you want to register for this free event, follow this link.
Steven Feuerstein will be giving a couple of sessions and my friend Alex Nuijten from AMIS will be performing the SQL and PL/SQL Quiz as a closing keynote, together with [...]

I love PL/SQL, and…

Thursday, September 6th, 2007

  Like Alex has blogged on the AMIS Technology blog there is a site I want you all to visit. It’s one of Steven Feuerstein’s Pet Peeves and it’s all about the PL/SQL language and what could be improved in it. I Love PL/SQL, and.. is a site where you can cast your vote on existing [...]