In this chapter you will learn about Oracle MERGE statement and using subquery in DML statements. Please note the result of subquery, whether single-row or multiple-row. You can download this material here