Title: (Optional) Construct a multi-table insert statement.
Course: Database Design and Management (Oracle) (10052) > Section: Applying Data Manipulation Language

Construction should include using the following format:

- Unconditional statement

INSERT ALL
INTO [table name] VALUES [data, data, data, data]
INTO [table name] VALUES [data, data, data, data]

- Conditional statement

INSERT ALL
WHEN [column name] IN [value, value, value] THEN
INTO [table name] VALUES [data, data, data, data]
WHEN [column name] IN [value, value, value] THEN
INTO [table name] VALUES [data, data, data, data]