CASE statement in Analytical functions does not beautify

[Rahul P]

Eg:

SELECT SUM(COUNT(*)) over(ORDER BY case when 'X' = 'X' then null else dbms_random.value end) FROM dual;

Does not beautify.

But this does.

SELECT SUM(COUNT(*)) over(ORDER BY dbms_random.value) FROM dual;

 

[Marco Kalter]

The PL/SQL Beautifier currently does not support analytical functions. This is on the list of enhancement requests.