sql – Jessitron

Spring Security for h2-console

June 27, 2020June 15, 2020 by jessitron

In Spring Boot example apps, H2 is the easiest database to get started with. Its data is in memory or in a local file. When the app is running in development mode, you can access the database at /h2-console. It gives you a lovely little SQL admin app. That is, after you turn it on … Read moreSpring Security for h2-console

Stupid Oracle Tricks #1: SQL substitution variables

September 23, 2011 by jessitron

A common behaviour of a program, and therefore of my SQL script to replicate the program, is:1) Retrieve some value from reference data2) Use it repeatedly in SQL statements If this reference data differs by environment or by day, this adds a manual step to the SQL script. Here’s a neat trick to save the … Read moreStupid Oracle Tricks #1: SQL substitution variables