A. Multitable INSERT statements can insert each computed row into more than one table. This is achieved by specifying multiple INTO clauses in the INSERT statement, each corresponding to a different table. Here's an example:
INSERT ALL INTO table1 (column1, column2) VALUES (value1, value2) INTO table2 (column3, column4) VALUES (value3, value4) SELECT * FROM source_table;
In this example, the computed rows from the source_table are inserted into both table1 and table2.
C. Multitable INSERT statements can be performed on external tables using SQL*Loader. External tables allow you to access data in external files as if it were in a regular database table. Here's an example:
INSERT ALL INTO table1 (column1, column2) VALUES (value1, value2) INTO table2 (column3, column4) VALUES (value3, value4) SELECT * FROM external_table;
In this example, the data from the external_table is inserted into both table1 and table2.
F. Multitable INSERT statements can be performed on relational tables. Relational tables
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
tom100men
2 months, 1 week agoarchit4321
2 months, 1 week agoArslanAltaf
2 months, 2 weeks agoArslanAltaf
2 months, 2 weeks agokesammy9
1 year, 4 months ago