Snippet Name: INSERT With Returning Clause Description: The RETURNING clause was implemented as part of the Oracle 10g release and is used to return information about the effected rows after issuing Data Manipulation Language (DML) statements. Also see:» Create Table INSERT (CTAS) » Inserting into SELECT statement » INSERT WITH CHECK OPTION » INSERT FIRST WHEN » INSERT ALL WHEN » INSERT ALL » INSERT WHEN » INSERT: Using A Record » INSERT with Select » INSERT: Multiple Column Table Or View ... » INSERT: Multiple Column Table Or View ... » INSERT: Single Column Table Or View » FORALL Insert » INSERT Comment: (none) Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 04th, 2009
Description: The RETURNING clause was implemented as part of the Oracle 10g release and is used to return information about the effected rows after issuing Data Manipulation Language (DML) statements.
Also see:» Create Table INSERT (CTAS) » Inserting into SELECT statement » INSERT WITH CHECK OPTION » INSERT FIRST WHEN » INSERT ALL WHEN » INSERT ALL » INSERT WHEN » INSERT: Using A Record » INSERT with Select » INSERT: Multiple Column Table Or View ... » INSERT: Multiple Column Table Or View ... » INSERT: Single Column Table Or View » FORALL Insert » INSERT
INSERT INTO <table> (c1, c2, .., cn) VALUES (v1, v2, .., vn) RETURNING <expression> INTO <variables> UPDATE <table> SET (c1) = (v1), (c2) = (v2), (cn) = (vn) WHERE <condition> RETURNING <expression> INTO <variables> DELETE FROM <table> WHERE <condition> RETURNING <expression> INTO <variables>
