I’ve found that formatting certain SQL that contains XML functionality doesn’t work in the editor in version 10, whereas it did in 9.7. e.g.
select extractvalue (column_value,’/DATASET/TEXT’) text from xmltable (’/DATASET’ passing xmltype(‘hello’));
All the formatter seems to do is change the case. 9.7 also changed the alignment.
The formatter settings are the same in both versions. Is this possibly a bug?