Thursday, February 07, 2019

Tales of mystery and imagination of DELETE RETURNING INTO

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.



Am I the only one who finds very odd this statement in the documentation of
DELETE ... RETURNING INTO?

"returning_clause
This clause lets you return values from deleted columns, and thereby eliminate the need to issue a SELECT statement following the DELETE statement."

I mean, what do you really expect to find AFTER issuing a DELETE?

The editor must have been copying and pasting the text from the INSERT RETURNING INTO...

This mistake is present in all the versions of SQL Reference Manual, 18c included, to this date.

No comments:

Post a Comment

I appreciate your comment however bear in mind that I might not have the time to reply soon.
Normally I do not reply to all comments but I am glad if you found something useful or if you learned something new, in that case I strongly encourage you to promote the article with the +1 google button.
Flavio