# CTE Resource Center - Verso - Database Design and Management (Oracle) Task 2056844181

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Construct a multi-table insert statement.

Definition

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]

Other Related Standards

NBEA Achievement Standards for Information Technology

Enter data and edit fields and records.