PL/SQL & SQL CODING GUIDELINE 34 - Avoid procedure or function calls between a SQL operation and an implicit cursor 08-13
PL/SQL & SQL CODING GUIDELINE 32 - Avoid using %NOTFOUND directly after the FETCH when working with BULK OPERATIONS and LIMIT clause. Use [array_name].COUNT() instead to check whether further FETCHs are needed 08-13
PL/SQL & SQL CODING GUIDELINE 31 - Always use %NOTFOUND instead of NOT %FOUND to check whether a cursor was successful 08-07
PL/SQL & SQL CODING GUIDELINE 28 - Try to use ANSI-join syntax, if supported by your ORACLE version 06-07
PL/SQL & SQL CODING GUIDELINE 27 - Always use table aliases when your SQL statement involves more than one source 06-07
PL/SQL & SQL CODING GUIDELINE 26 - Always specify the target columns when executing an insert command 06-07