I has been quite some time since I posted anything on my blog. That is mainly because I am busy with other things at the moment:
I will be presenting at the OGh Apex Event in Zeist (the Netherlands). I will be doing a presentation on how to build a plug-in for Apex, together with Alex Nuijten.
AMIS will be sponsoring the SQL Challenge in April. I have made a couple of questions for that. Lucas Jellema also made a couple of questions and we are now in the process of reviewing and approving them.
I will be doing (more...)
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 something is wrong (no data found or something like that). I know, suppressing errors is wrong, but in this case I will log the error. I just didn’t want it to appear in my data because the receiving application will generate errors and reject the (more...)
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. I have been publishing stuff on AllThingsOracle.com.
I have been appointed Track Leader for the Developer’s Toolkit for (more...)
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 from the internet.
On Saturday I went to the River Walk with Chet Justice, Jeff Smith, Dan McGhan and Galo Balda. Here we went to see The Alamo, had dinner at Café Ole and met up with Tim Gorman and Kellyn Pot’Vin.
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 day and got a lot of replies right away.
Frits Hoogland @fritshoogland
@patch72 AFAIK, old computer systems registered everything in uppercase. I know of old govmt systems. prbly people just kept on doing that.
That would be a very plausible explanation. We do a lot (more...)
SQL today is the foundation for any successful application. Whether it is a SOA implementation, an ADF or APEX application, a Forms application or any other usage of the Oracle Database (or any other relational database), SQL is key for the success. AMIS has embraced the evolution of SQL through the subsequent releases of the Oracle Database - trying to stay abreast of the latest features and adopting new functionality whenever it made pragmatic sense. In 2004 we developed the 7Up training - that introduced Oracle developers who started their Oracle careers with Oracle7 to the wonders of Oracle 9i. (more...)
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 them when I have some time again.
I also added an option for you to show your appreciation for my work and donate using Paypal.
You can find the new plugins at the homepage http://bar-solutions.com and then follow the menu on the left:
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 change to the code?
All questions that cannot be easily answered, except for the ‘go back in time’ one. You can’t (yet). This is where version control comes in.
I have worked with a number of version control systems and they all have their pros (more...)
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 new product worth $1475 to give away.
How can you ‘win’ one of these licenses? Just write up why you really, really deserve a copy. Write up what problem will be fixed if you have source control or maybe in what nasty situation you got (more...)