Free sample data of our solar system
About two years ago I introduced a couple of free sample data sets on GitHub (https://github.com/gvenzl/sample-data). You can read the […]
Technology
Percentage calculations using SQL Window Functions
Sometimes you have the requirement to calculate percentages on some values of your data. There are multiple ways of doing
How to cancel long-running queries in Oracle Database
This is a short blog post about a tiny little feature that you are probably unaware of but can make
Technology
Manually publish images to GitHub Container Registry (GHCR)
This is just a short little post on how to manually publish images to GitHub Container Registry (GHCR). Looking at
Technology
Everything you always wanted to know about Oracle Database NLS_LANG and character sets
I have recently come across the Oracle Database Globalization Support again and the question of what character set is used
Technology
SOLVED: Oracle XE: ORA-00821: Specified value of sga_target is too small
tl;dr Open ${ORACLE_HOME}/assistants/dbca/templates/XE_Database.dbc with a text editor Find <InitParamAttributes><InitParams> Add the following XML tag under <InitParams>: <initParam name=”cpu_count” value=”2″/>
Technology
How to get the month name in the IntelliJ copyright velocity template
Every time I try to create a copyright profile in IntelliJ (or PyCharm), I find myself googling around the web
Introducing gvenzl/oracle-xe: Oracle Database XE Docker images
One of the things that kept me busy lately was experimenting with how much an Oracle XE database setup could
Technology
How to list dependencies of a rpm package via dnf
The other day while writing up the blog post How to install Oracle Database 18c XE on Oracle Linux 8 I