Print Thread
Beautifier Error - Case on Analytic Function
#63290 02/16/22 12:46 PM
Joined: Mar 2009
Posts: 32
M
mamv Offline OP
Member
OP Offline
Member
M
Joined: Mar 2009
Posts: 32
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

Re: Beautifier Error - Case on Analytic Function
mamv #63297 02/16/22 12:56 PM
Joined: Aug 1999
Posts: 21,745
Member
Offline
Member
Joined: Aug 1999
Posts: 21,745
Analytic functions are indeed not yet supported.


Marco Kalter
Allround Automations

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4