Community

Oracle: MERGE ‘Monkey-business’

(David Fitzjarrell) Oracle can do some, well, strange things when fixing issues caused by the optimizer. For 10g releases up to 10.2.0.x Oracle chose to silently ignore a message and eliminate an outer join on the MERGE statement under certain conditions. Let’s examine this and see exactly what Orac

Read More - Register for Free Membership

Tags: