When I try to use the PL/SQL Beautifier with CTEs it doesn't work, here is an example that gets the "PL/SQL Beautifier could not parse text":
WITH "TestCTE" AS (SELECT * FROM dba_jobs) SELECT * FROM "TestCTE";
But if I break the line at the first SELECT, and then select the text up to the last ) and choose to Beautify the code it works.
Example: (select just "SELECT * FROM dba_jobs")
WITH "TestCTE" AS (
SELECT * FROM dba_jobs) SELECT * FROM "TestCTE";
Any chance this will be fixed in 8.0? (I often have to take code generated by Cognos as one huge long line and Beautify it so I can read it to see what is going on, and it would be much easier if I didn't have to break the line, and then select a portion of it.)