Introducing Oracle Database 23c Free – Developer Release
Oracle Database 23c Free – Developer Release is a new, free offering of the industry-leading Oracle Database that enterprises worldwide rely on every […]
How to write an anonymous PL/SQL function and use it in your SQL statement
Have you ever encountered a situation when you were in the middle of writing a SQL query and thought, “if
Setup free Let’s Encrypt SSL/TLS Certificates for NGINX Reverse Proxies
If you have your website running behind an NGINX Reverse Proxy, you may be wondering how you can enable HTTPS
How to auto-mount an NFS share using systemd
If you want to auto-mount an NFS share during boot time, you may run into the issue that by the
How to disable and remove WordPress post revisions
By default, WordPress stores revisions for all your posts when you draft or update them. It’s a useful feature when
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
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