Insert with subquery « Insert Delete Update « Oracle PL / SQL

1.Perform more complicated inserts using sub-selects
2.Merge into a table
3.Insert into ... select
4.Conditional INSERT Statement
5.Insert bulk by insert ... into ... select
6.To insert records into a table using a subquery:
7.Use bulk collect and rownum to insert first 10 records
8.Adding Multiple Rows to a Table