CAST Rules

58 Rules

ID	Name	Severity
1558	Package naming convention - prefix control	medium
1560	Package Function naming convention - prefix control	medium
1562	Package Stored Procedure naming convention - prefix control	medium
1564	Cursor naming convention - prefix control	medium
1574	Use at most one statement per line	medium
1576	Use varchar2 instead of char and varchar	medium
1578	Avoid using LONG & LONG RAW datatype for Table Columns	medium
1580	Avoid using execute immediate	critical
1582	Avoid large Tables - too many columns	medium
1588	Use WHEN OTHERS in exception management	medium
1596	Avoid using "nullable" Columns except in the last position in a Table	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
1634	Avoid unreferenced Tables	medium
7404	Avoid unreferenced views	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
7786	Avoid long Table or View names	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
7814	Avoid Tables not using referential integrity	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
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
7852	Database view naming convention - prefix control	medium
7854	Database table naming convention - prefix control	medium
7856	Avoid Tables with too many columns on an OLTP system	medium
7860	Avoid unreferenced Functions and Procedures	medium
7898	SQL Function naming convention - prefix control	medium
7900	Stored Procedure naming convention - prefix control	medium
7902	Avoid SQL queries that no index can support	medium
7904	Avoid SQL queries on XXL tables that no index can support	high
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
7950	Avoid definition of synonym as PUBLIC in PL/SQL context	medium
7952	Avoid synonym with both private & PUBLIC Definition in PL/SQL context	medium
7958	Avoid orphaned synonyms in PL/SQL context	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
8080	Avoid exists independent clauses	high
8082	Avoid Tables without Primary Key	high

58 Rules

Sign In