Oracle returning into, oraclereturning

Oracle returning into, oraclereturning

The returning into statement is used to return the value after the statement is executed. The specific results before or after execution are returned, as described below:

The returning into statement of the delete statement returns the result before the delete statement;
The returning into statement of the insert statement returns the result after insert.
The returning into statement of the update statement returns the result after update.
Returning into statement and return generic
The insert into values Statement supports the returning statement, but the insert into select statement does not.
The merge statement does not support the returning statement.

For example, the following statements are stored, and v_age is a declared variable.

<Span style = "font-size: 18px;"> insert into t_test values (1, 'hangsan', '27') returning age into v_age; update t_test set age = '28' returning age into v_age; delete t_test returning age into v_age; </span>