1 billion row challenge in SQL and Oracle Database
On the 1st of January 2024, Gunnar Morling launched The One Billion Row Challenge, fitting for a great start to the new […]
Technology
SQL
Announcing the general availability of the SQL:2023 Standard
We are pleased to announce the publication of the new SQL Standard version by the International Standards Organization (ISO), SQL:2023,
Technology
New SQL:2023 Standard now published
Yesterday ISO published the new SQL:2023 Standard, making that day a special day for me as this is the first
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
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