Bar Solutions WebLog

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 in because you didn’t have it.

I won’t be the only judge, but the guys at Redgate will help me decide who ‘wins’ the licenses.

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:

[Software - Plug-ins]

Currently the following plugins have been rebuilt:

• ColumnEdit
• CommentLine
• Favorites
• InitCaps
• ReConnect
• SaveSeparate
• Template
• ToggleReadOnly

Update 2013-01-22: Editor Enhancement has been added.

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.

Continue reading »

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 have voted, my task is to figure out which abstracts have the highest rating.

Continue reading »

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 entire set of data.

Continue reading »