CAST Rules

59 Rules

ID	Name	Severity
1101000	Never use SQL queries with a cartesian product (SQL)	medium
1101002	Never use SQL queries with a cartesian product on XXL Tables (SQL)	critical
1101004	Avoid non-indexed SQL queries	medium
1101006	Avoid non-indexed XXL SQL queries	critical
1101008	Avoid non-SARGable queries	medium
1101010	Avoid NATURAL JOIN queries	medium
1101012	Avoid specifying column numbers instead of column names in ORDER BY clauses	medium
1101014	Avoid queries using old style join convention instead of ANSI-Standard joins (SQL)	medium
1101016	Avoid Artifacts with too many parameters (SQL)	medium
1101018	Avoid using the GROUP BY clause	medium
1101020	Avoid using quoted identifiers	medium
1101022	Avoid Tables without Primary Key (SQL)	medium
1101024	Avoid using dynamic SQL in SQL Artifacts	medium
1101026	Always define column names when inserting values	medium
1101028	Use MINUS or EXCEPT operator instead of NOT EXISTS and NOT IN subqueries	medium
1101030	Avoid Artifacts with queries on too many Tables and/or Views	medium
1101032	Avoid EXISTS and NOT EXISTS independent clauses (SQL)	high
1101034	Avoid using DISTINCT in SQL SELECT statements	medium
1101036	Use ANSI standard operators in SQL WHERE clauses	medium
1101038	Avoid OR conditions testing equality on the same identifier in SQL WHERE clauses	medium
1101040	Avoid empty catch blocks (SQL)	high
1101042	Table naming convention - character set control (SQL)	medium
1101044	View naming convention - character set control (SQL)	medium
1101046	Package naming convention - prefix control (SQL)	medium
1101048	Package Function naming convention - prefix control (SQL)	medium
1101050	Package Stored Procedure naming convention - prefix control (SQL)	medium
1101052	Use WHEN OTHERS in exception management (SQL)	high
1101054	Never use WHEN OTHERS THEN NULL	high
1101056	Avoid large Tables - too many columns (SQL)	medium
1101058	Avoid mixing ANSI and non-ANSI JOIN syntax in the same query	medium
1101060	Avoid using LIKE conditions starting with a wildcard character	medium
1101062	Avoid using multiple statements per line (SQL)	medium
1101064	Avoid cascading Triggers (SQL)	medium
1101066	Avoid improperly written triangular joins with XXL tables	high
1101068	Avoid synonym with both private and public definition	medium
1101070	Avoid explicit comparison with NULL	medium
1101072	Avoid not aliased Tables	medium
1101074	Avoid Tables aliases ending with a numeric suffix	medium
1101076	Avoid unqualified column references	medium
1101078	Always prefer PRIVATE to PUBLIC synonym	medium
1101080	Avoid orphaned synonyms	medium
1101082	Avoid looping chain of synonyms	medium
1101084	Avoid Cursors inside a loop (SQL)	critical
1101086	Always use VARCHAR2 and NVARCHAR2 instead of CHAR, VARCHAR or NCHAR	medium
1101088	Avoid using LONG and LONG RAW datatypes	medium
1101090	Avoid Tables without a clustered Index (SQL)	medium
1101092	Avoid Procedures using an Insert, Update, Delete, Create Table or Select without including error management (SQL)	high
1101094	Avoid Stored Procedures not returning a status value (SQL)	medium
1101096	Avoid SQL injection in dynamic SQL for Oracle	critical
1101098	Avoid Artifacts with a Complex SELECT Clause (SQL)	medium
1101100	Avoid Functions and Procedures doing an Insert, Update or Delete without managing a transaction (SQL)	medium
1101102	Avoid using LIKE conditions without wildcards	medium
1101104	Avoid XXL tables without primary key / unique key constraint / unique index	high
1101106	Avoid tables without primary key / unique key constraint / unique index	high
1101108	Avoid Cobol SQL Cursors without FOR READ ONLY or FOR FETCH ONLY or FOR UPDATE or BROWSE ACCESS clauses	medium
1101112	Avoid LOCK TABLE statements in SQL code for COBOL Programs	medium
1101114	Avoid "SELECT *" queries (SQL)	medium
1101116	Avoid using SQL queries inside a loop (SQL)	critical
1101118	Avoid redundant indexes (SQL)	medium

59 Rules

Sign In