Oracle 更新并返回值
问题描述：
我在一张大容量表上有一个更新声明.它一次只更新一行.
I am having a Update Statement on a large volume table.
It updates only one row at a time.
Update MyTable
Set Col1 = Value
where primary key filters
执行此更新语句后，我还需要一个值作为回报，以避免在同一个表上使用 Select Query 以节省资源.我的语法是什么来实现这一点?
With this update statement gets executed I also want a value in return to avoid a Select Query on a same table to save resources.
What will be my syntax to achieve this?
答
您可以使用 RETURNING 关键字.
You can use the RETURNING keyword.
Update MyTable
Set Col1 = Value
where primary key filters
returning column1,column2...
into variable1,variable2...