Home

Queries should not SELECT too many columns

Rule description

  • Queries should not SELECT too many columns

 

Non-compliant Code Example

SELECT          --Non complaint code (Select query containing columns more then default defined limit of 6 columns)
    NAME,
    ADDRESS,
    CREDIT_LIMIT,
	AREA_CODE,
	PHONE_NUMBER,
	LANDMARK,
	TOTAL_EXPENSE
FROM
    CUSTOMERS
WHERE
	CREDIT_LIMIT IS NOT NULL
Visual Expert 2020
 VEPLSQLRULE152