@mrsowa

The Likely Obvious Oracle Tip #12

Feb 28 · 3 min read · Recently, I had an interesting case in my project. The issue involved a simple table with several NUMBER/VARCHAR2 columns and a CLOB column. This column was intended for very long texts, such as prose

The Likely Obvious Oracle Tip #11

Feb 23 · 2 min read · Introduction SQL Developer Command Line is a tool I frequently use on various occasions. It's worth mentioning tools like projects, which lower the entry barrier for implementing CI/CD processes in da

The Likely Obvious Oracle Tip #8

Feb 19 · 2 min read · One of the new features offered by Oracle Database 26ai is the enhancement of the DEFAULT ON NULL clause for columns during UPDATE. In this article, I will present the key concepts and my personal opinion on this improvement and the concept itself. I...

The Likely Obvious Oracle Tip #10

Feb 18 · 5 min read · Intro Visual Studio Code is a tool I use every day. As an APEX Developer, I probably use only some of its features, but it's clear that this tool has made my daily work much easier. In this article, I'll focus on selected features, so if you're inter...

The Likely Obvious Oracle Tip #9

Feb 17 · 2 min read · Among the many new improvements introduced with Oracle Database 23/26ai, the new capabilities of the GROUP BY clause caught my attention. In short, GROUP BY has become more flexible in terms of available syntax, matching ORDER BY in this regard. Star...