This project contains examples of unit testing of Oracle SQL queries and PL/SQL code using the 'Math Function Unit Testing' design pattern. The project introduces a new general method for choosing ...
This project has the code and other artefacts for small SQL projects, including mp4 recordings that explain the project. The sums_products subproject has the scripts and artefacts for a blog post, A ...
when you want to SELECT return values of functions or calculation formulas without using a table. Example: When you want to get the current date When you want to get the current date (timestamp) in ...