Beautifier Error - Case on Analytic Function - 02/16/22 12:46 PM
Hi,
This also happened on the previous version, but would love to see it fixed in version 15.
When you use a CASE inside an analytic funcion beautifier gives an error:
select dummy, ROW_NUMBER() OVER (ORDER BY CASE WHEN dummy = 'X' THEN 1 ELSE 0 END) rn from dual
Best,
Manuel
This also happened on the previous version, but would love to see it fixed in version 15.
When you use a CASE inside an analytic funcion beautifier gives an error:
select dummy, ROW_NUMBER() OVER (ORDER BY CASE WHEN dummy = 'X' THEN 1 ELSE 0 END) rn from dual
Best,
Manuel