When programming PL/SQL, you want to structure the code so that it does what it is supposed to and, if changes are necessary, you can easily see where they’re needed. After all, your goal is well-written code that performs in a reasonable time frame and is bug-free whenever possible. Check out these models of PL/SQL code:

image0.jpg