I have been awfully quiet on my blog lately. I think that is because I have been busy with other things, like my garden and stuff like that. There are some ‘techie’ thing I have done in the meantime, though, I have submitted a couple of abstracts for Tech14. Hope at least one of them […]
Read morePL/SQL vs SQL
There is a ‘rule’, I think it was created by Tom Kyte, stating: If you can do it in SQL, do it in SQL. I came across some code the other day that makes perfect sense to do then you are running an Oracle 10g (or earlier) instance. I rewrote the code to use only […]
Read moreOracle PL/SQL Programming 6th edition by Steven Feuerstein
I have reviewed the latest edition of Oracle PL/SQL Programming. This is not a book, at least for me, that I would read front to back. I use it mostly as a reference, but the great thing about this book is that you can also use this book to learn programming PL/SQL from scratch.
Read moreTypical
After a presentation by Lucas Jellema I decided to try something with types in Oracle. One of the issues posed in this presentation was that the type cannot include self-reference. Neither direct nor indirect.
Read moreKScope14
This year, from June 22 – June 26, the best convention in the world, ODTUG‘s KScope14 will be held in Seattle, Washington. I am already looking forward to meeting some ‘old’ friends again, creating new friends and seeing some of the best content by presenters from all over the world. Some of the presentations I […]
Read moreAPEX 5.0 Early Adopter
The long awaited Early Adopter installation is finally available at http://apexea.oracle.com. You can request a workspace here to play around with the new version. I have just been playing around with it for about an hour an from what I’ve seen it’s a big change to what we’re used to since APEX 4. Not only […]
Read moreCreating hidden paths in Powerpoint
When you are, like me, creating presentations you might want to have the possibility to hide certain slides and only show them when time permits. You can of course just skip over the slides during your presentation, but that is not a good practice IMHO. It is better to add these slides as hidden slides […]
Read moreFavorites
Last couple of weeks I have been working on an update of the Favorites plugin for PL/SQL Developer. After extensive testing by Erik van Roon, Henk Jan van Wijk and Marcel Hoefs I decided to release it. Hope you like it.
Read moreFinding wildcards
We sometimes use wildcard characters in the values of our columns. This makes it hard to find just these records. When looking for these records you want to search for the wildcard character, but this will return the other records as well.
Read moreRedgate Source Control for Oracle
At the KScope12 conference Redgate held a live lab to develop their new tool: Redgate Source Control for Oracle. I was involved then already to help make this tool work the way developers want. To help everyone use this tool Redgate is friendly to provide me with two (2) five (5) user licenses to their […]
Read more