It has been almost a year (March 21st 2022) since Alex asked me if I knew someone who could be his co-author for a new book he was asked to write. Before I really knew what I was getting myself into I said yes, I know someone. I’ll do it.And thus began a period of […]
Read moreMySQL and Oracle
Over the last couple of months I have been working on a MySQL based system for my current customer. This made me realize, once again, how easy we can do stuff in an Oracle based system.On one hand this is kind of awkward, not being able to do what you are used to, on the […]
Read moreConnect PL/SQL Developer to the Oracle cloud
Connecting to the Oracle cloud using SQLDeveloper is easy. You just download the wallet to your machine and tell SQLDeveloper to use the contents of this zip file for your connection. Ofcourse this is easy, because SQLDeveloper is an Oracle product, it would be bad advertising if this was a hard thing to do. Connecting […]
Read moreReconnect Plugin
On the forum of PL/SQL Developer there was a message by my good friend Erik van Roon. He was having trouble with Reconnecting. Even my plugin didn’t help him. I figured I should update the plugin.
Read moreConstraints
The other day a friend called me with a question on constraints. “I have a table where the combination of two columns must be unique”. My response was: “Use a Unique Constraint on these two columns”.That should work, however…
Read moreLog errors
Just a quick note of something I ran into at my current assignment. I have to import data from external tables into persistent tables. This proces normally is just inserting data into the table, but sometimes a file can be sent in more than once.
Read moreRecursive Subquery
At my current assignment we are processing files coming from an online system to be inserted into our database (kind of a data warehouse). This is done using external tables and a scheduled job. The job just checks if there is a file available and will process this. The trouble is that the files might […]
Read moreACE Director
It has now been a week since I have been promoted to ACE Director. I want to thank everybody for their wishes. Directly after being promoted I was off to Dublin for the UKOUG Ireland conference. That is why I didn’t respond to every tweet individually. Please don’t think I didn’t like the tweets or […]
Read morePolymorphic Table Functions – Part 2
In my previous post I wrote about a possible use-case for Polymorphic Table Functions. I also wrote that I had some ideas to implement extra functionality to make the function more generic. After attending DOAG Konferentz und ausstellung 2018 and UKOUG Tech18 I finally came around to publishing my new version.
Read morePolymorphic Table Functions
I have been working on a presentation on Polymorphic Table Functions. During this time I was looking for a real use case for Polymorphic Table Functions. I came up with an example which is not very useful in real life, but very useful to explain the technique. At my current job I came across a […]
Read more