Monthly Archives: October 2017

ODC Appreciation Day: Collections in SQL

Oren Nakdimon Leave a Reply

Here’s my contribution to the ODC Appreciation Day. Overview Last week I had the privilege to participate in the EOUC Database ACES Share Their Favorite Database Things session at Oracle OpenWorld, so I think that the best topic to write about, as part of the ODC Appreciation Day, is the one I talked about in […]

Continue reading

RETURNING INTO – Enhancement Suggestion

Oren Nakdimon 3 Replies

The RETURNING INTO clause is one of my favorite features. It returns data from the rows that have been affected by the DML statement, and as I wrote in this previous post: For INSERT it returns the after-insert values of the new row’s columns. For UPDATE it returns the after-update values of the affected rows’ […]

Continue reading