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