[Oracle] insert into select, select into, and update select statements in SQL

[Oracle] the SQL code of the insert into select, select into, and update select statements in SQL -- table1 is required -- join subquery conditions can be written after where, you can also ignore insert into table1 t1 (id, name) select id, name from table2 t2 where t2. field = t1. a field; SQL code -- select * into table2 from table1 -- tmp_table does not exist, new, PL/SQL requires the following statement: create table tmp_table as select id from tbl_project SQL code -- update select update table1 t1 set t1.name = (select name from table2 t2 wehre t2.id = t1.id)