Oracle PL/SQL Best Practices Part 1

Themis instructor John Mullins helps you become familiar with best practices when coding Oracle PL/SQL best practices. Examples of before and after are provided.

[@αλήθεια-σ4κ]

Subject starts at @10:20

[@MrXyzAbcdQwerty]

Hi John, Thanks for teaching these simple, yet useful, practices. I have a doubt on PRAGMA EXCEPTION_INIT. As you have mentioned at 35.40, Oracle has not provided names for many exceptions. It has just provided ORA numbers. Why Oracle has not named them like NO_DATA_FOUND, DUP_VAL_ON_INDEX? If it is possible for providing numbers, what is blocking Oracle team to provide names as well?

[@SinskariBoi3366three]

Oracle only associates a small number of internally defined exceptions with an exception name in the sys.STANDARD package. Kinds of exceptions in PL/SQL, Named System Exceptions, Named Programmer defined Exceptions, Unamed System Exceptions, Unnamed Programer defined exceptions.