PL/SQL & SQL CODING GUIDELINE 43 - Use 1 as lower boundary and COUNT() as upper boundary when looping over a dense array 04-21
PL/SQL & SQL CODING GUIDELINE 41 - Always use a CURSOR FOR loop to process the complete cursor results unless you are using bulk operations 03-03
PL/SQL & SQL CODING GUIDELINE 38 - Always use CASE instead of NVL2 if parameter 2 or 3 of NVL2 is either a function call or a SELECT statement 09-05
PL/SQL & SQL CODING GUIDELINE 37 - Always use COALESCE instead of NVL, if parameter 2 of the NVL function is a function call or a SELECT statement 08-28
PL/SQL & SQL CODING GUIDELINE 35 - Try to use CASE rather than an IF statement with multiple ELSIF paths 08-24