New “Sales History” Sample Schema in Oracle 23c
The newest version of the Oracle sample schema “Sales History” (SH) finally contains current data again and is easier to install than the previous versions. If you work with star schemas, the SH schema is a must. Last week, I had the pleasure to teach…
SQL Performance Tips in Execution Plans of Oracle 23c
Oracle 23c is like Christmas for me. There are many surprises to be found. This weekend I discovered another nice little enhancement. In the last days, I developed and tested some demo scripts that I plan to show at my next conference sessions at APEX…
Enhanced Partitioning Metadata in Oracle 23c
Oracle 23c has a lot of small, but useful enhancements that makes life of developers easier. For example two new columns in the data dictionary views for partition metadata. The description of the LONG data type in the SQL Language Reference of the Oracle documentation…
Oracle Database 23c on a Mac with an M-Series Chip
Starting Position I got my MacBook Pro 16″ with an Apple M1 Max chip with 10 cores, 64 GB RAM and 4 TB disk in November 2021. At that time, the M1 chip had already been on the market for a year and I knew…
GROUP BY Extensions in Oracle 23c
Since a few days, Oracle Database 23c Free Developer Release is available. It contains many new features that are interesting for developers, especially some nice little extensions in SQL that we missed since years. Let’s start with an easy one in this blog post. In previous…