Column references — i.e. names of columns in an expression — are valid value expressions. That means that a column reference can stand where a value expression is expected.
Example:
MERGE INTO ... AS ...
USING ... AS "SRC" ON ...
WHEN NOT MATCHED THEN INSERT ("ID", ...) VALUES ("SRC"."ID", ...)
In the example above the content of VALUES is a list of value expressions. Column references are useful in that scenario.
Acceptance Criteria
Column references are accepted where value expressions are required.
Situation
Column references — i.e. names of columns in an expression — are valid value expressions. That means that a column reference can stand where a value expression is expected.
Example:
In the example above the content of
VALUESis a list of value expressions. Column references are useful in that scenario.Acceptance Criteria