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 […]
Read moreMonthly Archives: September 2007
Using inline views to achieve SPOD
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 […]
Read moreHow old…
…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.
Read moreDutch Toad Usergroup…
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 […]
Read moreI love PL/SQL, and…
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 […]
Read more