SQL – Gerald on IT

Non-Positional INSERT statement – the insider story

Oracle Database 23.9 implements the non-positional INSERT statement. In my social media posts, I called out that Oracle Database is […]

My recent blog post about Oracle Database 23.7 has generated significant interest in one particular feature: materialized columns. In this

SQL is a declarative, English-like domain language for querying, analyzing, and manipulating data. SQL originated from relational databases but has

📰 Bringing APEX and PL/SQL to D&D – Sean Stuber built some awesome APEX analytics for the popular Dungeons &

On the 1st of January 2024, Gunnar Morling launched The One Billion Row Challenge, fitting for a great start to the new

We are pleased to announce the publication of the new SQL Standard version by the International Standards Organization (ISO), SQL:2023,

Yesterday ISO published the new SQL:2023 Standard, making that day a special day for me as this is the first

Have you ever encountered a situation when you were in the middle of writing a SQL query and thought, “if

Sometimes you have the requirement to calculate percentages on some values of your data. There are multiple ways of doing