The most important Oracle pl/sql right now is:
SELECT * FROM USER_ERRORS
I’ve been “developing” some new functions, and I was getting sick and tired of being told:
Warning: execution completed with warning
function MissingProd Compiled.
Now I can know what’s wrong, and fix it, before reloading my complete scheme. Yay!