Skip to content

Oracle Thoughts

Jacek Gębals blog on Oracle database development, PL/SQL best practices, unit testing, and utPLSQL framework.

Contains my personal opinions and experiences.

Topics covered

  • PL/SQL development — performance, pitfalls, naming conventions, exception handling
  • Unit testing — focusing on utPLSQL v3, previously looking at utPLSQL v2 and ruby-plsql-spec comparisons
  • SQL*Plus — errorlogging feature, some nice scripting patterns
  • CI/CD for Oracle — running database tests on continuous integration platforms
  • Oracle SQL — MERGE statement caveats, INSERT LOG ERRORS, implicit datatype conversions etc.

Browse the Blog tab for all articles, or use the search above.