I would like to change SQL Developer “Format” rules (F7). specifically, I would like:
- a CASE to start in a new line
- all CASE clause to appear in one line (ie , from CASE till END and its alias- all to appear in one line)
- and the same for analytic function (i.e analytic function, such as row_number, would start on a new line, and all of it will appear in one line)
Any idea how to do it?
for example:
SELECT empno, CASE WHEN deptno = 1 THEN 1 ELSE NULL END AS case_, ROW_NUMBER() OVER(PARTITION BY deptno ORDER BY empno DESC)AS rn from emp;
Now I get:

Here is the Advance Setting I now use:
