And while I am on the topic, the formatter of measures is ugly, it should also process long lines
/* unformatted */
SELECT * FROM DUAL MODEL DIMENSION BY (1 my_very_long_column_name_1a, 2 my_very_long_column_name_2a, 3 my_very_long_column_name_3a, 4 my_very_long_column_name_4a, 5 my_very_long_column_name_5a, 6 my_very_long_column_name_6a, 7 my_very_long_column_name_7a, 8 my_very_long_column_name_8a, 9 my_very_long_column_name_9a, 10 my_very_long_column_name_10a, 11 my_very_long_column_name_11a, 12 my_very_long_column_name_12a) MEASURES ( 1 my_very_long_column_name_1b, 2 my_very_long_column_name_2b, 3 my_very_long_column_name_3b, 4 my_very_long_column_name_4b, 5 my_very_long_column_name_5b, 6 my_very_long_column_name_6b, 7 my_very_long_column_name_7b, 8 my_very_long_column_name_8b, 9 my_very_long_column_name_9b, 10 my_very_long_column_name_10b, 11 my_very_long_column_name_11b, 12 my_very_long_column_name_12b) RULES ();
Does not format at all!
And if add some rules,
SELECT * FROM DUAL MODEL DIMENSION BY (1 my_very_long_column_name_1a, 2 my_very_long_column_name_2a, 3 my_very_long_column_name_3a, 4 my_very_long_column_name_4a, 5 my_very_long_column_name_5a, 6 my_very_long_column_name_6a, 7 my_very_long_column_name_7a, 8 my_very_long_column_name_8a, 9 my_very_long_column_name_9a, 10 my_very_long_column_name_10a, 11 my_very_long_column_name_11a, 12 my_very_long_column_name_12a) MEASURES ( 1 my_very_long_column_name_1b, 2 my_very_long_column_name_2b, 3 my_very_long_column_name_3b, 4 my_very_long_column_name_4b, 5 my_very_long_column_name_5b, 6 my_very_long_column_name_6b, 7 my_very_long_column_name_7b, 8 my_very_long_column_name_8b, 9 my_very_long_column_name_9b, 10 my_very_long_column_name_10b, 11 my_very_long_column_name_11b, 12 my_very_long_column_name_12b) RULES (my_very_long_column_name_1b[1,2,3,4,5,6,7,8,9,10,11,12]=0);
then it formats only a little bit …
/* Formatted on 03.06.2013 15:02:47 (QP5 v5.252.13127.32847) */
SELECT *
FROM DUAL
MODEL
DIMENSION BY (1 my_very_long_column_name_1a, 2 my_very_long_column_name_2a, 3 my_very_long_column_name_3a,