RETURNING into statement

The RETURNING into statement can be specified in the DML Statement of ORACLE. It is easy to use, and it is not much different from the select into statement. The use of RETURNING statements can simplify PL/SQL programming in many cases. DELETE operation: RETURNING returns the results before the DELETE operation; INSERT operation: RETURNING returns the results after the INSERT operation; UPDATE operation: the RETURNING statement returns the results after the UPDATE operation. The insert into select statement on www.2cto.com is not supported. The MERGE statement does not support the RETURNING statement. You can assign values to variables according to the above rules. Update f_firmfunds set donebalance = donebalance + p_amount where firmid = p_firmid returning donebalance into v_donebalance;