Blog: jooq (Lukas Eder)

408 blogs updated: 40 min. ago
How to Fetch All Current Identity Values in Oracle
Oracle 12c has introduced the useful SQL standard IDENTITY feature, which is essentially just syntax sugar for binding a sequence to a colum...
16-07-2019 12:26:42 jooq (Lukas Eder) Advanced
How to Use jOOQ's Commercial Distributions with Spring Boot
Spring Boot is great to get started very quickly with what the Spring Boot authors have evaluated to be useful defaults. This can be a lot o...
26-06-2019 14:18:54 jooq (Lukas Eder) Advanced
How to Write a Simple, yet Extensible API
How to write a simple API is already an art on its own. I didn't have time to write a short letter, so I wrote a long one instead. Mark Twai...
06-06-2019 13:03:07 jooq (Lukas Eder) Advanced
Using IGNORE NULLS With SQL Window Functions to Fill Gaps
I found a very interesting SQL question on Twitter recently: Hi @sfonplsql we have some scenario, Let us 01Jan Mkt Value 100, 02Jan 120, nex...
24-04-2019 10:58:14 jooq (Lukas Eder) Advanced
Calling an Oracle Function with PL/SQL BOOLEAN Type from SQL
One of the most wanted features in the Oracle database is the BOOLEAN type. The SQL standard specified it a while ago, and RDBMS like Postgr...
16-04-2019 15:08:04 jooq (Lukas Eder) Advanced
The Difference Between SQL's JOIN .. ON Clause and the Where Clause
A question that is frequently occurring among my SQL training s participants is: What's the difference between putting a predicate in the JO...
09-04-2019 15:50:16 jooq (Lukas Eder) Advanced
The Cost of Useless Surrogate Keys in Relationship Tables
What's a good natural key? This is a very difficult question for most entities when you design your schema. In some rare cases, there seems ...
26-03-2019 12:43:44 jooq (Lukas Eder) Advanced
Calculating Weighted Averages When Joining Tables in SQL
I stumbled upon a very interesting jOOQ question on Stack Overflow that required the calculation of a weighted average. Why is that. Problem...
15-03-2019 12:15:01 jooq (Lukas Eder) Advanced
How to Statically Override the Default Settings in jOOQ
When configuring a jOOQ runtime Configuration, you may add an explicit Settings instance, which contains a set of useful flags that change j...
14-03-2019 15:40:41 jooq (Lukas Eder) Advanced
How to Calculate a Cumulative Percentage in SQL
A fun report to write is to calculate a cumulative percentage. For example, when querying the Sakila database, we might want to calculate th...
14-02-2019 17:44:48 jooq (Lukas Eder) Advanced

© Jiri Pinkas | this project on GitHub | related: JavaVids | Maven Central Repository Search | Java školení | Top SQL Blogs | monitored using: sitemonitoring

Top Java Blogs is a Java blog aggregator (with English-written blogs only) focused on Java SE, Java EE, Spring Framework and Hibernate.