Rules tagged with: SQL

Integration of SQL (DQL, DML and TCL) in stored objects.

• G-3110 Always specify the target columns when coding an insert statement.

  Reliability
• G-3115 Avoid self-assigning a column.

  Maintainability
• G-3120 Always use table aliases when your SQL statement involves more than one source.

  Maintainability
• G-3130 Try to use ANSI SQL-92 join syntax.

  Maintainability
• G-3140 Try to use anchored records as targets for your cursors.

  Reliability
• G-3145 Avoid using SELECT * directly from a table or view.

  Reliability
• G-3150 Try to use identity columns for surrogate keys.

  Reliability
• G-3160 Avoid visible virtual columns.

  Reliability
• G-3170 Always use DEFAULT ON NULL declarations to assign default values to table columns if you refuse to store NULL values.

  Reliability
• G-3180 Always specify column names instead of positional references in ORDER BY clauses.

  Reliability
• G-3182 Always specify column names/aliases instead of positional references in GROUP BY clauses.

  Reliability
• G-3183 Always specify column aliases instead of expressions in GROUP BY clauses.

  Maintainability
• G-3185 Never use ROWNUM at the same query level as ORDER BY.

  Reliability
• G-3190 Avoid using NATURAL JOIN.

  Reliability
• G-3192 Avoid joining tables with the USING clause.

  Reliability
• G-3195 Always use wildcards in a LIKE clause.

  Maintainability
• G-3210 Always use BULK OPERATIONS (BULK COLLECT, FORALL) whenever you have to execute a DML statement for more than 4 times.

  Reliability
• G-3220 Always process saved exceptions from a FORALL statement.

  Reliability
• G-3310 Never commit within a cursor loop.

  Reliability
• G-3320 Try to move transactions within a non-cursor loop into procedures.

  Maintainability
• G-3330 Avoid autonomous transactions.

  Reliability

21 total