PL/SQL packages are great! But there is one package feature you shouldn’t use: Initialization. Your first inclination should be to avoid it. Steven Feuerstein explains why.
Steven discusses when it makes sense to choose a string-indexed associative array (one of the three types of PL/SQL collections)
Lazy can be a good developer characteristic or a terrible one depending on how and when applied. Steven and Marlyn look at examples of each.
Watch out for always using an IF statement, consider using a CASE expression, in SQL as well as PL/SQL, and then look for opportunities to use CASE statements as well.
1 866 887-1670