Strict profile

Advanced, medium controversy.

74 rules added by Strict

Strict also enables every rule of Essential and Balanced — 171 rules in total.

• G-0010 New Always format database code consistently.

  Minor Maintainability
• G-1230 Avoid tables without relationships.

  Major Maintainability
• G-1240 Try to index foreign key columns.

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

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

  Minor Maintainability
• G-3194 Always specify INNER or OUTER within JOIN TO ONE.

  Major Maintainability
• G-4210 Try to use CASE rather than an IF statement with multiple ELSIF paths.

  Minor Maintainability
• G-4220 Try to use CASE rather than DECODE.

  Major Maintainability
• G-4260 Avoid inverting boolean conditions with NOT.

  Minor Maintainability
• G-4270 Avoid comparing boolean values to boolean literals.

  Minor Maintainability
• G-4370 Avoid using EXIT to stop loop processing unless you are in a basic loop.

  Major Maintainability
• G-4375 Always use EXIT WHEN instead of an IF statement to exit from a loop.

  Minor Maintainability
• G-4390 Avoid use of unreferenced FOR loop indexes.

  Major Reliability
• G-5010 Try to use a error/logging framework for your application.

  Critical Reliability
• G-5040 Avoid use of WHEN OTHERS clause in an exception section without any other specific handlers.

  Critical Reliability
• G-7125 Always use CREATE OR REPLACE instead of CREATE alone.

  Major Maintainability
• G-7127 Always use the FORCE option when creating views.

  Major Maintainability
• G-7150 Try to remove unused parameters.

  Major Maintainability
• G-7160 Always explicitly state parameter mode.

  Major Reliability
• G-7170 Avoid using an IN OUT parameter as IN or OUT only.

  Major Reliability
• G-7250 Never use RETURN in package initialization block.

  Major Reliability
• G-7310 Avoid standalone procedures – put your procedures in packages.

  Minor Maintainability
• G-7320 Avoid using RETURN statements in a PROCEDURE.

  Major Maintainability
• G-7410 Avoid standalone functions – put your functions in packages.

  Minor Maintainability
• G-7440 Never use OUT parameters to return values from a function.

  Major Maintainability
• G-7510 Always prefix Oracle supplied packages with owner schema name.

  Blocker Security
• G-7515 Always prefix Oracle supplied object types with owner schema name.

  Blocker Security
• G-7520 Avoid using deprecated units in your own code.

  Major Maintainability
• G-7710 Avoid cascading triggers.

  Major Maintainability
• G-7740 Never handle multiple DML events per trigger if primary key is assigned in trigger.

  Critical Reliability
• G-8410 Always use application locks to ensure a program unit is only running once at a given time.

  Blocker Reliability
• G-8510 Always use dbms_application_info to track program process transiently.

  Critical Reliability
• G-9101 Always follow naming conventions for global variables.

  Minor Maintainability
• G-9102 Always follow naming conventions for local variables.

  Minor Maintainability
• G-9103 Always follow naming conventions for cursor variables.

  Minor Maintainability
• G-9104 Always follow naming conventions for record variables.

  Minor Maintainability
• G-9105 Always follow naming conventions for collection variables (arrays/tables).

  Minor Maintainability
• G-9106 Always follow naming conventions for object variables.

  Minor Maintainability
• G-9107 Always follow naming conventions for cursor parameters.

  Minor Maintainability
• G-9108 Always follow naming conventions for IN parameters of functions and procedures.

  Minor Maintainability
• G-9109 Always follow naming conventions for OUT parameters of functions and procedures.

  Minor Maintainability
• G-9110 Always follow naming conventions for IN/OUT parameters of functions and procedures.

  Minor Maintainability
• G-9111 Always follow naming conventions for record type definitions.

  Minor Maintainability
• G-9112 Always follow naming conventions for collection type definitions (arrays/tables).

  Minor Maintainability
• G-9113 Always follow naming conventions for exceptions.

  Minor Maintainability
• G-9114 Always follow naming conventions for constants.

  Minor Maintainability
• G-9115 Always follow naming conventions for subtypes.

  Minor Maintainability
• G-9116 Always follow naming conventions for record fields.

  Minor Maintainability
• G-9201 Always follow naming conventions for tables.

  Minor Maintainability
• G-9202 Always follow naming conventions for table/view columns.

  Minor Maintainability
• G-9203 Always follow naming conventions for indexes.

  Minor Maintainability
• G-9204 Always follow naming conventions for primary key constraints.

  Minor Maintainability
• G-9205 Always follow naming conventions for unique constraints.

  Minor Maintainability
• G-9206 Always follow naming conventions for foreign key constraints.

  Minor Maintainability
• G-9207 Always follow naming conventions for check constraints.

  Minor Maintainability
• G-9208 Always follow naming conventions for assertions.

  Minor Maintainability
• G-9209 Always follow naming conventions for global temporary tables.

  Minor Maintainability
• G-9210 Always follow naming conventions for views.

  Minor Maintainability
• G-9211 Always follow naming conventions for sequences.

  Minor Maintainability
• G-9212 Always follow naming conventions for synonyms.

  Minor Maintainability
• G-9213 Always follow naming conventions for triggers.

  Minor Maintainability
• G-9214 Always follow naming conventions for PL/SQL packages.

  Minor Maintainability
• G-9215 Always follow naming conventions for functions.

  Minor Maintainability
• G-9216 Always follow naming conventions for procedures.

  Minor Maintainability
• G-9217 Always follow naming conventions for object types.

  Minor Maintainability
• G-9218 Always follow naming conventions for object type attributes.

  Minor Maintainability
• G-9219 Always follow naming conventions for collection types.

  Minor Maintainability
• A-0950 Always follow naming conventions for application items.

  Minor Maintainability
• A-0960 New Try to give modal dialogs a Cancel button.

  Minor Maintainability
• A-0980 New Try to set the compatibility mode to the latest version.

  Minor Maintainability
• A-1080 New Avoid defining CSS inline at page level.

  Minor Maintainability
• A-1120 New Always define an icon for buttons using an icon template.

  Minor Maintainability
• A-1340 Avoid pages without an authorization scheme.

  Critical Security
• A-3070 New Try to define a default value for Interactive Grid checkbox and switch columns.

  Minor Maintainability

74 total