Hi,
I have one scenario where I want to understand how exactly the sequence of INSERT and UPDATE statement executed, if i select MERGE operation in DB adapter.
Scenario -
I have Employee 1 which already exist in table but this time I am changing one of the attribute value. So after execution It will update that particular filed in table for Employee 1.
At the same time, From SOA Service I am passing completely new entry for Employee 2. So It should technically insert that Employee 2.
I am using Oracle 11g database.
I want to know, Whether Insert operation execute first or Update ?
Is there any oracle documentation available from Oracle where they have categorically specified this concept ?
In addition to above question, I would like to understand that whether this merge operation executes in bulk or per record ?
Can I control this types of executions by setting any property ?
Thanks & Regards,
Darshan Sonagara