The new DreamCoder for MySQL include a powerful feature in the SQL and Stored procedure editor, the new mark object option. You can stick out any object in your code with a single double click.

Mentat Technologies is happy to announce the new version of DreamCoder for PostgreSQL version 2.2, a powerful Windows solution for PostgreSQL administration and database development.

In a previous blog I talked about turning triggers on and off using semaphores. I created a semaphore for every table I needed along with its programs to set and unset the semaphore and to get its current state. This was a rather cumbersome process, because for every new trigger I needed to add these programs to the package. Both the spec and the body need to be recompiled which renders all dependant code to become invalid. This week I came across a similar problem with a new project. I figured I could use roughly the same solution but I needed to find a better way to implement it.

Read the rest of this article at http://bar-solutions.com/weblog/?p=321

Mentat Technologies is happy to announce the new version of DreamCoder for PostgreSQL version 2.0, a powerful Windows solution for PostgreSQL administration and database development.

This new version includes SSH tunneling support, as well as more than 50 new features and improvements over the previous version.

I came across the need to define the first day of next month based on the current systemdate. I can do this using the following code:

add_months(to_date(’01'||to_char(sysdate,’MMYYYY’),’DDMMYYYY’),1)

But the I remembered that there was a post on the oracledeveloper.nl forum with similar date functions.

If you don’t know where to start your with your program, recursion might be an option. I am working on some (perhaps useless) package code to convert an integer into a boolean representation. When I am converting the integer, I don’t know where to start my conversion. If the integer is relatively small and I start with a high bit (too big) then the overhead is relatively big.

Oracle has decided to add Conditional Compilation to Oracle 10g Release 2. As Bryn Llewellyn states in his white paper Conditional Compilation in Oracle Database 10g Release 2. Unusually, but for very compelling reasons, the feature has been made available in patchsets of releases of Oracle Database earlier than the one that introduced the feature. It is available in Oracle 10g Release 1 (10.1.0.4.0) and if you have the right support contract, it can even be turned on Oracle 9i (9.2.0.6).

I’m sure everybody ran into an error of some sort when using Oracle. Some errors are really obvious, you are trying to select a column that doesn’t exist, assigning a variable that hasn’t been declared, that kind of errors. But there are also errors that you don’t run into that often, maybe it’s even the first time you run into this error. What do you do when you run into a new error, i.e. new to you. You try to find out what the error is and what might be a resolution. Of course there is the Oracle documentation where you can find all the errors and which might help you with the resolution.

Oracle 9i and up provide you with a new keyword: DEFAULT. This means you can get to the default values of a column when doing an insert or update.

I have tried some things with this on my 10G XE database and I have come up with the following script to test it all (a bit).

When I was presented with the possibilities of Rulegen it made me wonder: How can these rules be tested. Rulegen is a tool to create rules in the database by just typing in some SQL queries. Rulegen will then use this input to generate a couple of triggers and a package to enforce these rules.