SQL Daily (@sqldaily) 's Twitter Profile
SQL Daily

@sqldaily

Daily Oracle SQL tips from the Oracle Developer Advocates for SQL

ID: 3001841930

linkhttp://blogs.oracle.com/sql calendar_today29-01-2015 17:45:15

2,2K Tweet

25,25K Followers

4 Following

SQL Daily (@sqldaily) 's Twitter Profile Photo

Oracle Database 23ai extends the RETURNING clause for UPDATE by allowing you to state OLD = previous value NEW = current value e.g. UPDATE ... SET col = ... RETURNING OLD col, NEW col INTO old_var, new_var #SQL