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
Misc
Free sample data sets for everyone!
It’s actually been quite a while since I put together these free sample data sets for everyone but it just
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
Technology
How to install Oracle Database 18c XE on Oracle Linux 8
It has been more than two and a half years since Oracle 18c XE has been released for Linux. Since
Technology
How to build your own Thanksgiving shopping list app with JavaScript
Thanksgiving is about to arrive in the US, and, as every year, millions of people and I are preparing our
Technology
25 years of Java – Happy Birthday!
Today 25 years ago Java made its first public appearance. Back then, Java promised to be a general-purpose programming language