SQLcl is turning into a absolute beast or universal swiss knife if you will. I’m having so much funk with the utility of this tool. Today I want to talk about how to get one key feature of Liquibase to work with SQLcl and its implementation of Liquibase. It does a lot of it amazingly…

Unable to debug due to clouds or firewalls in your datacenter? No more, SQL Developer 20. 2to the rescue.
As you may recall, I do not like processes that requires a GUI for things that should be possible to do repeatedly and be part of automatic deployment of a full environment. Thus I want the whole wallet creation to be done in scripts. No, the root certs don’t change often and no it would…
I held a live stream for SWEOUG that presented what my last two blogs covered. It was my first ever and while it was a bit uncomfortable to set up to not see your audience it worked well. In fact it was really enjoyable and I look forward to doing more. In the stream Ilmar Kerm made…
In the last blog post I wrote about how to access an HTTP-resource and the ACL needed for it. That works great for HTTP, but as the world is turning to HTTPS it is not enough in most cases. In this post I will look at how to set up the trust store in a…
One of the things people want more and more often is to somehow read from a web-resource using a database. It could be to just get the HTML off of a website or access REST via PL/SQL, or grab a JSON-file residing on a public website. No matter which it is we need to declare that…
I was recently asked to investigate why a job that was to update a few thousand rows took an hour where it had been proven to do the work in just seconds in other environments. Was this new environment set up with much more data? No, actually much less as the tests before had been…
Yes, I admit it. I am sometimes not at all as structured as I would like to think. Recently I had worked on a query that had taken me many hours to get just right. When I was done I celebrated with a coffee break (I’m a Swede after all) and after it I started working…
This is a short update to the presumed bug I wrote about recently in this post. After a few back and forth with Oracle support it turns out this is a well-known (to them) effect of using dbms_random in SQL. The base for this seems to be a bug report in 10g that was declared “not…
If you live your life in an editor writing code or configuration files, you need Visual Code in your life. Yes it is a Microsoft product and possibly surprising to use in environments that are not heavy on Microsoft or even using Windows operating system. But the truth is that it may well be the…
Sign up with your email address to receive our weekly news