Denotes the in-memory table that stores IN-list elements.
Insert rows into table or view.
The insert construct contains two nodes: one INSERT node and one node that represents either the target view or table.
Denotes the INTERSECT operation.
This node returns rows in both the inner and outer tables and eliminates redundant duplicate rows.
Denotes the INTERSECT ALL operation.
This node returns rows in both the inner and outer tables and retains redundant duplicate rows.