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

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Construct a MERGE statement.

Definition

Construction should include using the following format:

MERGE INTO table-name USING table/view/subquery
ON  what join condition
WHEN MATCHED THEN UPDATE SET
Col1 = Col2 value
WHEN NOT MATCHED THEN
INSERT (column_list)
VALUES (column_values)

Other Related Standards

NBEA Achievement Standards for Information Technology

Enter data and edit fields and records.