Which two statements are true about conditional INSERT ALL? (Choose two.)
Posted: Sun Jun 11, 2023 3:54 pm
Which two statements are true about conditional INSERT ALL? (Choose two.)
A. Each row returned by the subquery can be inserted into only a single target table.
B. A single WHEN condition can be used for multiple INTO clauses.
C. Each WHEN condition is tested for each row returned by the subquery.
D. It cannot have an ELSE clause. E. The total number of rows inserted is always equal to the number of rows returned by the subquery.
A. Each row returned by the subquery can be inserted into only a single target table.
B. A single WHEN condition can be used for multiple INTO clauses.
C. Each WHEN condition is tested for each row returned by the subquery.
D. It cannot have an ELSE clause. E. The total number of rows inserted is always equal to the number of rows returned by the subquery.