Oracle Merge Statement allows to use more than one source and execute different operations in the same statement. Using Oracle Merge you …