Rules tagged with: Variable

Variables and data types.

• G-2110 Try to use anchored declarations for variables, constants and types.

  Reliability
• G-2120 Try to have a single location to define your types.

  Maintainability
• G-2130 Try to use subtypes for constructs used often in your code.

  Maintainability
• G-2135 Avoid assigning values to local variables that are not used by a subsequent statement.

  Reliability
• G-2140 Never initialize variables with NULL.

  Maintainability
• G-2145 Never self-assign a variable.

  Maintainability
• G-2150 Avoid comparisons with NULL value, consider using IS [NOT] NULL.

  Reliability
• G-2160 Avoid initializing variables using functions in the declaration section.

  Reliability
• G-2170 Never overload variables.

  Maintainability
• G-2180 Never use quoted identifiers.

  Maintainability
• G-2185 Avoid using overly short names for explicitly or implicitly declared identifiers.

  Maintainability
• G-2190 Avoid using ROWID or UROWID.

  Reliability
• G-2210 Avoid declaring NUMBER variables, constants or subtypes with no precision.

  Reliability
• G-2220 Try to use PLS_INTEGER instead of NUMBER for arithmetic operations with integer values.

  Reliability
• G-2230 Try to use SIMPLE_INTEGER datatype when appropriate.

  Reliability
• G-2310 Avoid using CHAR data type.

  Reliability
• G-2320 Never use VARCHAR data type.

  Maintainability
• G-2330 Never use zero-length strings to substitute NULL.

  Maintainability
• G-2340 Always define your VARCHAR2 variables using CHAR SEMANTIC (if not defined anchored).

  Reliability
• G-2410 Try to use boolean data type for values with dual meaning.

  Maintainability
• G-2510 Avoid using the LONG and LONG RAW data types.

  Maintainability
• G-2610 Never use self-defined weak ref cursor types.

  Maintainability

22 total