BUG: case statements in the WHERE clause & the beautifier

when you include case statements in the where clause, the where clause and any additional statements after it all appear on the same line after beautification.
e.g.

Code:
WHERE
t.description = CASE WHEN p_desc = 'ALL' THEN t.description ELSE p_desc END
AND t.another_column = 'Y'
AND t.different_column = 'Z'
will all appear on one line.
I am using version 7.0.0.1050
 
This also happens when using CASE statements in pl/SQL packages. The entire CASE statement is written on one single line.

Helene
 
Back
Top