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 …
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