Recent content by dbms_photoshop

Another one "could not parse text": SELECT CASE WHEN decode(1,1, CASE WHEN 1 = 1 THEN 1 ELSE 0 END) = 1 THEN 1 END FROM dual; But more important bugs relative to beautifier is: 1. Beautify all procedures 2. model clause Do you have a plan for when this will be fixed...

Beautifier could not parse text while case statement followed after over or keep keywords. Examples: SELECT MAX(dummy) keep(dense_rank FIRST ORDER BY case when (1 = 1) then 1 else 0 end) result FROM dual; select row_number() over (ORDER BY case when 1 = 1 then 1 else 0 end) rn from dual...

Hi! Is there any way to create script for beautify all procedures for some schema? Let's consider 2 cases. 1. With import/export. 2. Without import/export. 1. With import/export. I can done it with this three steps 1) Export all procedures. 2) Generate script for beautify all of them. Like...