Killian Lynch

How to put an OCI API Gateway in front of an existing Fusabase environment, so your app gets a public HTTPS endpoint while ORDS stays private behind it.

Read-only partitions and subpartitions let you block inserts, updates, and deletes. How to create, check, and change them in the Oracle Database.

Real-time materialized views give you fresh results from a stale materialized view at query time. A demo of ON QUERY COMPUTATION and the FRESH_MV hint.

How Global Temporary Tables work in the Oracle Database, including ON COMMIT DELETE and PRESERVE ROWS, and how they differ from Private Temporary Tables.

Virtual columns in the Oracle Database aren't stored physically but are calculated on the fly when selected. A quick example using NHL shooting percentage.

PIVOT rotates rows into columns and UNPIVOT turns columns back into rows. A simple Oracle Database example using quarterly sales data by region.

Identity columns give you an easy way to create unique numeric IDs without sequences and triggers. Covers GENERATED ALWAYS, BY DEFAULT, and ON NULL.

The PL/SQL Function Result Cache lets you easily cache commonly calculated function results. This blog walks through a practical example with timings.