The returning into statement is used to return the value returned after the statement is executed, returning the result before or after the execution, as described below:
The returning into statement of the DELETE statement returns the result before the delete;
The returning into statement of the INSERT statement returns the result after the insert.
The returning into statement of the UPDATE statement returns the result after the update.
Returning into statement and return generic
The INSERT INTO VALUES statement supports the returning statement, and the INSERT INTO SELECT statement is not supported.
The merge statement does not support returning statements.
Example: The following statements are in storage, V_age is a variable declared
<span style= "FONT-SIZE:18PX;" >insert into t_test values (1, ' Zhangsan ', ' "V_age;update ') returning age to t_test returning set age = ' + ', age int o V_age;delete t_test returning age into v_age;</span>
Oracle returning into