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.
A table like the emp table cannot be expressed as an object type. The table has a column mgr which is a reference to another employee.
So I tried something like this:
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 am looking forward to:
In the Developer’s Toolkit track:
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 has the look an feel changed to flat , but I think the biggest visible change is (more...)
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.
I have been appointed Track Leader for the Developer’s Toolkit for (more...)
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...)
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:
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...)