QUESTION 51
Choose two
Which two statements are true about conditional INSERT
ALL?
A) Each row returned by the subquery can be inserted into
only a single target table.
B) It cannot have an ELSE clause.
C) The total number of rows inserted is always equal to
the number of rows returned by the subquery
D) A single WHEN condition can be used for multiple INTO
clauses.
E) Each WHEN condition is tested for each row returned by
the subquery.
Correct Answer: CE
D正确 DE,见下例 E 测试正确 C 多个INSERT 应该是倍数关系
解析:官档语法:
https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/INSERT.html#GUID-903F8043-0254-4EE9-ACC1-CB8AC0AF3423
https://oracle-base.com/articles/9i/multitable-inserts
conditional_insert_clause
Specify the conditional_insert_clause to perform a
conditional multitable insert. Oracle Database filters each insert_into_clause
through the corresponding WHEN condition, which determines whether that
insert_into_clause is executed. Each expression in the WHEN condition must
refer to columns returned by the select list of the subquery. A single multitable
insert statement can contain up to 127 WHEN clauses.
INSERT ALL
WHEN order_total