Have you ever had to write a text, but didn’t know how to continue after the first sentence? Don’t worry, AI can fix that. Just go to this website, enter what you’ve got, and you…
In one of my older blogs “Dump VO query and it’s parameter with their values”, I described a technique on how to print or dump out a query and its parameters to the log when…
Es kommt immer wieder es vor, dass (Oracle-) Datenbankanwendungen "zu langsam" sind. Dann wird versucht herauszufinden woran es liegt und wenn man Glück hat findet sich eine Idee das verursachende SQL-Statement so zu ändern, dass…
In this blog, I show how to pass information from your ADF application to the DB session. This allows the DB administrator to identify problematic sessions on the DB side, like long-running SQL statements or…
Die Gruppierung von Daten ist eine wichtige Funktion der Datenanalyse. Attribute - wie z.B. "Preisklasse" - erleichtern oftmals die Gruppenbildung in einer BI-Anwendung. Manchmal muss ein BI-Nutzer jedoch seine Daten nach eigenen, neuen Gruppen zusammensetzen,…
Motivation Did you ever had a foreign PL/SQL-Package in Oracle that was not documented but you needed to understand what is going on inside the package?There are tools on the market that could help you…
Java 8 made a mini revolution and brought useful features like Nullable, which simplified the everyday life of a developer. It brought also long-awaited powerful features like lambda expressions and streams. Java programmers can use...
H2 is a handy thing to have in your Spring Boot toolbox. It is most known as an in-memory database. That is, it will not persist changes to disk. Generally, you create your tables during…
Maven is all about connectivity. It allows you to quickly specify a dependency in the pom.xml file and forget about it. Maven will handle it for you. It will download it when necessary. If the…
The simplest way to configure logging in your Spring Boot application is to modify or add some entries in application.properties file. So for our case of setting the location where the log files will be…