CAST Rules

45 Rules

ID	Name	Severity
1574	Use at most one statement per line	medium
1580	Avoid using execute immediate	critical
1588	Use WHEN OTHERS in exception management	medium
1598	Avoid Rule HINT /+ rule / or --+ rule in PL/SQL code	medium
1606	Triggers should not directly modify tables, a procedure or function should be used instead	medium
1608	Avoid cascading Triggers	medium
5550	Avoid having joins with more than 4 Tables	medium
5554	Avoid having SQL code in Triggers named "pre-record"	medium
5558	Based Data Blocks naming convention - represented table	medium
5560	Based Data Block Items naming convention - represented column	medium
5562	Not Based Data Blocks naming convention - prefix control	medium
5564	Not Based Data Block Items naming convention - prefix control	medium
5566	Use of call_form built-in Function from a centralized location	medium
5572	Avoid objects without COMMENT property	medium
7420	Avoid SQL queries with implicit conversions in the WHERE clause	medium
7660	Never use SQL queries with a cartesian product on XXL Tables	high
7662	Avoid SQL queries on XXL Tables with implicit conversions in the WHERE clause	high
7760	Avoid triggers, functions and procedures with a very low comment/code ratio	medium
7762	Avoid undocumented Triggers, Functions and Procedures	medium
7766	Avoid Artifacts with High Cyclomatic Complexity	medium
7768	Avoid Artifacts with High Depth of Code	medium
7770	Avoid Artifacts with too many parameters	medium
7772	Avoid Artifacts with High Essential Complexity	medium
7774	Avoid Artifacts with High Integration Complexity	medium
7776	Avoid Artifacts with High Fan-In	medium
7778	Avoid Artifacts with High Fan-Out	medium
7784	Avoid Artifacts with lines longer than X characters	medium
7790	Avoid Cursors inside a loop	critical
7806	Avoid Artifacts with Group By	medium
7808	Avoid Artifacts with SQL statement including subqueries	medium
7810	Avoid Artifacts with a Complex SELECT Clause	medium
7816	Avoid using GOTO statement	medium
7820	Never use SQL queries with a cartesian product	medium
7822	Avoid Artifacts with queries on more than 4 Tables	medium
7826	Forms naming convention - prefix control	medium
7828	Avoid Artifacts with High RAW SQL Complexity	medium
7840	Trigger naming convention - prefix control	medium
7842	Avoid large Artifacts - too many Lines of Code	medium
7860	Avoid unreferenced Functions and Procedures	medium
7900	Stored Procedure naming convention - prefix control	medium
7902	Avoid SQL queries that no index can support	medium
7946	Avoid queries using old style join convention instead of ANSI-Standard joins	medium
7948	Do not mix Ansi joins syntax with Oracle proprietary joins syntax in the same query	medium
7960	Avoid looping chain of synonyms in PL/SQL context	medium
8036	Avoid improperly written triangular joins with XXL tables in PL/SQL code	medium

45 Rules

Sign In