A Dev Gym Workout

RETURNING Data from DML Statements


The RETURNING clause allows you to retrieve values of columns (and expressions based on columns) that were modified by an insert, delete or update. Without RETURNING you would have to run a SELECT statement after the DML statement is completed, in order to obtain the values of the changed columns. So RETURNING helps avoid another roundtrip to the database, another context switch in a PL/SQL block. Use this workout to get up to speed on the many ways you can use RETURNING.
  • Instructor

    Steven Feuerstein*

  • Estimated Time

    60 Minutes

  • Difficulty

    Intermediate to Advanced

Oracle Account Text

You need an Oracle Account to take a workout. Click here to sign up.
Already a member of the Oracle Dev Gym? Click here to get back to work.

Exercises

Exercise Difficulty Time
Use RETURNING Clause to Avoid Unnecessary SQL StatementsIntermediate10
Quiz on Aggregate Functions in the RETURNING ClauseIntermediate2
Quiz on RETURNING Information from DELETEsIntermediate5
Quiz on RETURNING Column Values from DML StatementsIntermediate6
Quiz on RETURNING Column Values from DML StatementsIntermediate5
Quiz on RETURNING Record of Data in DML StatementIntermediate6
Quiz on RETURNING Column Values from DML StatementsIntermediate2
Quiz on RETURNING Record of Data in DML StatementIntermediate5
Quiz on Handling multiple rows of data in RETURNING clauseAdvanced6
Quiz on Aggregate Functions in the RETURNING ClauseAdvanced6
Instructor

*About Steven Feuerstein

Steven Feuerstein is a Senior Advisor at Insum Solutions (https://insum.ca), and is obsessed with the Oracle PL/SQL language, having written ten books on it (all published by O'Reilly Media). You will find an abundance of quizzes from Steven at the Dev Gym. Enjoy!

More from Steven Feuerstein