sql

1. insert into select

insert into table(a, b, c) select a, b, column from table1 where ...

2. UPDATE SELECT

DECLARE
	CURSOR RECORDS IS SELECT * FROM TABLE_NAME;
BEGIN
	FOR RECORD_ITEM IN RECORDS LOOP 
		DOSOMETHING;
	END LOOP;
END;