Rules tagged with: SQL

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

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

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

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

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

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

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

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

  Reliability
• G-3160Avoid visible virtual columns.

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

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

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

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

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

  Reliability
• G-3190Avoid using NATURAL JOIN.

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

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

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

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

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

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

  Maintainability
• G-3330Avoid autonomous transactions.

  Reliability

21 total