DML OPERATIONS

Multiple Table Insert in Oracle

INSERT INTO..SELECT statement can be used to insert data into multiple target tables based on certain conditions.

Types of Multiple Table Insert:

• UNCONDITIONAL ALL INSERT
• CONDITIONAL ALL INSERT
• CONDITIONAL FIRST INSERT
• PIVOT INSERT

UNCONDITIONAL

Insert operation in Oracle

Insert is a DML operation. Usually Insert means when we add rows into tables.

There are various ways rows can be added into tables.

Types of Insert operation:

• INSERT INTO VALUES CLAUSE
• COPYING DATA FROM OTHER