Oracle Merge function content

--minus to go to the difference set, take the first set to have one but the second set does not, and sort by the first field
SelectT.bumenbm fromT_HQ_BM TminusSelectB.bumenbm fromt_hq_bm2 B--intersect intersection, take two sets of all, and sort by the first fieldSelectT.bumenbm fromT_HQ_BM TintersectSelectB.bumenbm fromt_hq_bm2 b--union to re-merge, to repeat the record, and to sort by the first fieldSelectT.bumenbm fromT_HQ_BM TUnionSelectB.bumenbm fromt_hq_bm2 B--union All has a heavy merge, does not go to duplicate records, does not sortSelectT.bumenbm fromT_HQ_BM TUnion  AllSelectB.bumenbm fromt_hq_bm2 B--order by, coincident and sortedSelectT.bumenbm fromT_HQ_BM TUnion  AllSelectB.bumenbm fromT_HQ_BM2 bOrder  by 1 desc

Oracle Merge function content