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.
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.
