I have been busy with a lot of personal stuff lately. Took my daughters on a short camp with about 60 other girls. Visited a couple of friends, attended some birthday parties, had Steven over for a day, that kind of stuff. That means I didn’t really have the time to write up something for the blog.
Read moreNotes tool…
I have taken the last couple of weeks to create a new utility to keep track of the notes that come up during my work or other things when I’m behind my computer. It took some time out of my life, but I really like the result. I hope you download the tool and let […]
Read moreFinally…
Steven has arrived in The Netherlands. After having his flight from Oslo canceled due to technical problems (did they loose a wing or something like that) he arrived at Schiphol airport around 21:30. About 2 hours later than expected but definitely on time for the events scheduled for tomorrow. First there is the TOAD User […]
Read moreColumn editing in PL/SQL Developer
If you are using PL/SQL Developer as much as I do, you may be using the column editing mode. Press the Alt-key and drag your mouse to select some text. Now you can use a couple of options (like copy, cut and paste) on your selection. For instance, use the indent option to move you […]
Read moreFunctions as default values…
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 moreUsing 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 moreQDA on tables…
When you are implementing the QDA in an existing application, you may want to know what tables have the QDA implemented and what tables don’t have it implemented yet. I have created two SQL statements that retrieve this information from the data dictionary.
Read more