Home

Newline and control characters should not be used in string literals

Rule description

  • Newline and control characters should not be used in string literals

 

Non-compliant Code Example

SELECT
/* 
Customer table is for holding customer data such as Name, Address, etc.
Also it contains some crucial information like Credit limit, amount spent etc.
*/
    NAME,
    ADDRESS,
    CREDIT_LIMIT
FROM
    CUSTOMERS
Where ADDRESS like '%BUNGALOWS%      --Non compliant code (Newline and control characters used in string literals)
';
Visual Expert 2020
 VEPLSQLRULE37