Y Yeats Member² Sep 5, 2024 #1 SQL: select sysdate, row_number() over(partition by sysdate order by case when trunc(sysdate) >= trunc(sysdate) then '0' else '1' end) as rn from dual The beautifier caused an error when i try to beautify the sql above.
SQL: select sysdate, row_number() over(partition by sysdate order by case when trunc(sysdate) >= trunc(sysdate) then '0' else '1' end) as rn from dual The beautifier caused an error when i try to beautify the sql above.
Marco Kalter Administrator Staff member Sep 6, 2024 #1 Analytical functions are not yet supported by the PL/SQL Beautifier. This is on the list of enhancement requests.
Analytical functions are not yet supported by the PL/SQL Beautifier. This is on the list of enhancement requests.
