Summary of Insert statements in Oracle

In Oracle, insert statements are used: 1. insertinto table 1 (column name 1, column name 2, hellip;) values (value 1, value 2, hellip ;) 2. insert

In Oracle, insert statements are used: 1. insert into Table 1 (column name 1, column name 2, hellip;) values (value 1, value 2, hellip ;) 2. insert

In Oracle, the use of insert statements:

1. insert into Table 1 (column name 1, column name 2 ,......) Values (value 1, value 2 ,......)

2. insert into Table 1 (column name 1, column name 2 ,......)

Select column name 1, column name 2 ,...... From table 2

3. insert all -- unconditionally add

Into Table 1 values (column name 1, column name 2 ,......)

Into Table 2 values (column name 1, column name 2 ,......)

Select column name 1, column name 2 ,...... From table 3

4. insert all -- if the conditions are met, add

When condition 1 then into Table 1 values (column name 1, column name 2 ,......)

When condition 2 then into Table 1 values (column name 1, column name 2 ,......)

Select column name 1, column name 2 ,...... From table 3

5. insert first -- if the first condition is met, add

When condition 1 then into Table 1 values (column name 1, column name 2 ,......)

When condition 2 then into Table 1 values (column name 1, column name 2 ,......)

Select column name 1, column name 2 ,...... From table 3