insert into from select into fromoracle示例

INSERT INTO table_name (column1, column2, ...) SELECT column1, column2, ... FROM table_name WHERE condition;

Example:

INSERT INTO employees (employee_id, first_name, last_name) SELECT employee_id, first_name, last_name FROM temp_employees WHERE hire_date > '01-JAN-2022';