Hi,

Is it possible to alter the way in which beautify deals with the ON clause in MERGE? E.G:

MERGE INTO gtt_aupr_upload g
USING (SELECT *
FROM tanker_shipments) t
ON (g.berthing_slot_date_ts_tz = t.berthing_slot_date AND g.lng_tanker_name = t.aup_tanker_name AND g.terminal_user_name = t.aup_customer_name)
WHEN MATCHED THEN g.tash_id = t.id

I'd really like the ON to be broken at the 'AND's... or anything that doesn't just end up as one long line.

No, there is currently no option that controls this. This is on the list of enhancement requests.