PL/SQL “Don’ts” 5 & 6
uStart
endless loops
ØEach time you create a loop, think about how the code will exit from the loop.
ØUse CURSOR FOR loops or FOR loops whenever possible.
ØIf you do not need to interrupt processing, always use a FOR loop. This is much safer approach.
uReinvent the wheel
ØDon’t try to create code structures
that have already been developed for
you by Oracle.
ØReview an Oracle manual with
the list of built-in functions.
