Office Hours scripts. Contribute to ChrisSaxonOra/office-hours development by creating an account on GitHub.

Background As you probably know, I’m maintaining a parser for grammars used in SQL files for Oracle AI Database and PostgreSQL. As a result, I check for new statements and clauses in every version of ...

Introduction The script command was introduced with SQLcl 4.2. It is based on JSR 223, the Java Scripting API, and makes it possible to run JavaScript from SQLcl. This adds client-side control flow, f...

Many years ago, before I joined Oracle, I was working on a major modernisation project. We were replacing an existing non-Oracle system with an entirely new Oracle database application written from…

Introduction The APEXlang API Reference documentation went live a few days ago. You can also download the APEXlang EBNF grammar. In this post, Kris Rice explains the value of having an EBNF. Since the...

ALT: Drake's Disappointed Shrug

This book describes the new features in Oracle AI Database 26ai.

🚀 The utPLSQL project just got a refresh! We're happy to announce a new set of releases across the utPLSQL ecosystem: 📦 utPLSQL framework v3.2.01 📦 utPLSQL-java-api v3.2.4 📦 utPLSQL-cli v3.2.0 📦 utP...

Oracle DB Skills is a curated library of 100+ practical, documentation-backed guides for working with Oracle Database, organized by domain - oracle/skills

ALT: mike tyson laughs while sitting in front of a comedy central logo

There seems to be a school of thought in the tech community that a robust knowledge SQL is now optional. After all, with modern AI tools able to generate SQL from plain English, it seems “obv…

I have talked at KScope about the difference between ROWS and RANGE in the analytic window clause, but haven't yet blogged about it. Recentl...

25-30 years ago I worked a lot with the Danish developed ERP system called Concorde XAL. It ran on top of a database (choice of several, mos...

YouTube video by Oracle Developers

This book describes the new features in Oracle AI Database 26ai.

You might be wondering how a friend’s boat has any relation to the topic of software quality, but bear with me – we’ll get there in a second. But first, if you’ve got a Twit…

Last week, a new version of SQLcl was released, SQLcl 25.4. The release contains a lot of cool new features, but there is one tiny one in it that came thanks to yours truly. Of course, I can only take credit for filing an enhancement request, tracking down the Dev manager, and pestering him until he kindly agreed. And truthfully, it didn't really involve pestering.