Home

Columns to be read with a SELECT statement should be clearly defined

  • Maintainability
  • Major

Rule description

  • Columns to be read with a SELECT statement should be clearly defined

 

Non-compliant Code Example 

SELECT
    *       --Non compliant code (Select statement with all the columns)
FROM
    CUSTOMERS

Compliant Code Example

SELECT
    NAME ,    --Compliant code (Select statement defined specific columns)
    ADDRESS ,
    CREDIT_LIMIT
FROM
    CUSTOMERS
Visual Expert 2020
 VEPLSQLRULE97