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:

yes you can!

Two great ways to help us out with a minimal effort. Click on the Google Plus +1 button above or...
We appreciate your support!

latest articles