Another beautifier problem

[lspence8]

If I use a decode in my select statement and chose

 

[Covina]

Yes, It's annoying, I have insert/update/delete in the formatter to display one item in a row
currently, the formatter messes up my code for all oracle built in functions.

This is what I wrote and want to retain after I format:
decode(substr(hou.internal_address_line,3,1), '1', 'Elementary School', '2', 'Middle School' , '3', 'High School', 'Unknown') school_type

This is how formatter messes up:
DECODE(SUBSTR(hou.internal_address_line,
3,
1),
'1',
'Elementary School',
'2',
'Middle School',
'3',
'High School',
'Unknown') school_type

Hope 6.0 release will have all the goodies.