CASE / WHEN is indentend backwards
chatelao opened this issue · 2 comments
chatelao commented
IS:
- In my CASE / WHEN statements, the "WHEN" part is indented backwards:
SELECT job_id
, CASE
WHEN job_id = 'AD_PRES' THEN '123'
WHEN job_id = 'IT_PROG' THEN '456'
ELSE '059'
END case_test
FROM employees
WOULD LIKE:
- The WHEN parts to be aligned or even indeted too:
SELECT job_id
, CASE
WHEN job_id = 'AD_PRES' THEN '123'
WHEN job_id = 'IT_PROG' THEN '456'
ELSE '059'
END case_test
FROM employees
PhilippSalvisberg commented
This repository manages the guidelines for code style in this section: https://trivadis.github.io/plsql-and-sql-coding-guidelines/v4.2/3-coding-style/coding-style/ .
If you are using our formatter settings for SQL Developer then please post an issue in this repo: https://github.com/Trivadis/plsql-formatter-settings . If you are using other setting then please contact the ventor of your IDE. Thanks.
chatelao commented
Danke, mache ich doch gerne.