Did you know that you can ask the PL/SQL compiler to give you advice on how to improve the performance, maintainability, and overall behavior of your code?
In this episode Steven explores compile-time warnings in the PL/SQL language - you will be amazed at how much you can learn about (and be dismayed at in) your code.
See Steven's detailed blog on the subject, with lots of resources!
https://www.insum.ca/feuertip-31-i-warned-you-says-the-pl-sql-compiler/