Beta Released (

Beta Notes

Formatting/Parsing (QP5)

Code Analysis

New (QP 2280) : Rule 6705 (“An IF having ELSIF clauses should have an ELSE clause.”)

New (QP 2364) : Rule 6726 (“Consider replacing ‘(NOT) IN subquery’ by ‘(NOT) EXISTS subquery’.”)

New (QP 2365) : Rule 6727 (“NVL in a WHERE clause may disable the use of an index.”)

New (QP 2277) : Rule 6724 (“Check on PL/SQL block and loop label matching.”)

New (QP 2313) : Rule 6715 (“COMPRESS or NOCOMPRESS specified more than once.”)

Fix (QP 2304) : Rule 4806 (“Avoid use of unreferenced FOR loop indexes.”) RULE REMOVED.

Rule 2746 (“A CASE statement should have an ELSE clause”) : Topic text added.

Rule 2757 (“A CASE expression should have an ELSE clause to avoid it returning NULL”) : Topic text amended.

Rule 5920 (“Apply the invoker rights method to all stored code that executes dynamic SQL”) : Example code added.