Home

Quoted identifiers should not be used

Rule description

  • Quoted identifiers should not be used

 

Non-compliant Code Example

SELECT Id,
DECODE (statecode, 101, 'New York', 
    201, 'New Jersey', 
    301, 'Seattle', 
    401, 'San Francisco',
    'Unknown') As
"Service Center Location"              --Non compliant code (Quoted identifiers is used)
FROM cars
WHERE cars.Id < 1775

Compliant Code Example

SELECT Id,
DECODE (statecode, 101, 'New York', 
    201, 'New Jersey', 
    301, 'Seattle', 
    401, 'San Francisco',
    'Unknown') As
Service_Center_Location              --Compliant code (Quoted identifiers is not used)
FROM cars
WHERE cars.Id < 1775
Visual Expert 2020
 VEPLSQLRULE21