wsowa.hashnode.devThe Likely Obvious Oracle Tip #11Introduction 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 da1d ago·2 min read
wsowa.hashnode.devThe Likely Obvious Oracle Tip #8One 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...5d ago·2 min read
wsowa.hashnode.devThe Likely Obvious Oracle Tip #10Intro 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...6d ago·5 min read
wsowa.hashnode.devThe Likely Obvious Oracle Tip #9Among 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...Feb 17·2 min read
wsowa.hashnode.devThe Likely Obvious Oracle Tip #7Introduction From time to time, I log into the INTERNAL workspace to set up a new APEX workspace. In most cases, it is based on an existing database schema. In some situations, I need to create a new schema. Here, APEX offers us two options: creating...Feb 11·6 min read