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 morePL/SQL Developer plugins
As the people at Allround Automations are working hard to release version 10 of their great application PL/SQL Developer, I have been busy checking/rebuilding/extending my plugins. I have added toolbar buttons to all of commands supplied by my plugins. I am not done yet. I have some more plugins to do, but I will do […]
Read moreCase-Insensitive…
When building your queries you might want to search case-insensitive. We normally use the UPPER() function to accomplish this. This is kind of weird IMHO, because you have to uppercase the value you are looking for. I was wondering why we are not using the LOWER() function. I put this question on Twitter the other […]
Read moreUsing External Tables…
I have been appointed Track Leader for the Developer’s Toolkit for KScope13. This involves voting on abstracts. Everyone in the group should rate the abstracts on a scale of 1 to 5. Where 1 is not good (Not appropriate…) and 5 is very good (Highlight of the conference…). After all the members of the group […]
Read moreLong time no see
It’s been quite some time since my last post. It’s not that I haven’t been busy, just didn’t find the time or a subject to write a blog about. Until now. I came up with something I didn’t know. I have a pipelined table function where I want to suppress a record from appearing when […]
Read moreKScope12
Just back from a full week in San Antonio for KScope12. I really had a good time. ODTUG provides us with the best conference for developers in the world. Seen some great sessions, met up with some old friends, made a lot of new ones, met in real life with some people I knew only […]
Read moreVersion Control
When building software you often make a lot of changes to your code, only to find out is isn’t working anymore. What change broke the code? What was the previous, working, version like? Can I go back in time to undo my changes? And if you are working in a team: Who made the last […]
Read moreWhat’s he doing anyway…
I know I haven’t been really active on my blog lately, but that is mainly because I don’t have much energy left after a full day of work. Beside that, I am using most of my spare time to create my presentation for KScope12 and for a guest college at a school beginning next month. […]
Read more