Rules tagged with: Variable

Variables and data types.

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

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

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

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

  Reliability
• G-2140Never initialize variables with NULL.

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

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

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

  Reliability
• G-2170Never overload variables.

  Maintainability
• G-2180Never use quoted identifiers.

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

  Maintainability
• G-2190Avoid using ROWID or UROWID.

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

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

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

  Reliability
• G-2310Avoid using CHAR data type.

  Reliability
• G-2320Never use VARCHAR data type.

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

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

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

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

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

  Maintainability

22 total