Hi all,
Recently I switch to Toad 12.5.1.1,
before this I use Toad 11, usually when I want to generate merge statement using Toad, I just click the Export dataset button in the Data Grid and choose Export format: Merge Statement.
Usually after i click OK (if there's no primary key defined), it will prompt me to choose Primary keys for my table.
However, now Toad (12.5.1.1) didnt prompt me for the primary key after I click OK & directly generate the merge statement.
Then the generated merge statement become like this (snippet , in bold):
ON (A."" = B."")
WHEN NOT MATCHED THEN
INSERT (
I'm not sure whether this is related to Toad version or some setting is turned off,
if it's a setting can anyone help to illuminate me on which setting should I change?
Thanks in advance.