Trivadis PL/SQL & SQL Coding Guidelines v2.0

Version 2.0

PLSQL-and-SQL-Coding-Guidelines.pdf

• Released in August 2011
• Added error handling section
• Added rule 23: Always define your VARCHAR2 variables using CHAR SEMANTIC
• Added rule 30: Use BULK OPERATIONS (BULK COLLECT, FORALL) whenever you have to
  repeatedly execute a DML or SELECT command for more than 4 times.
• Added rule 31: Always use %NOTFOUND instead of NOT %FOUND to check whether a cursor was
  successful.
• Added rule 43: Use 1 as lower boundary and COUNT() as upper boundary when looping over a
  dense array.