retrieve old value while executing an update statement

From: codadilupo <yossarian99_at_operamail.com>
Date: Tue, 11 Mar 2008 10:06:07 +0100
Message-ID: <47d64b7f$0$21209$5fc30a8@news.tiscali.it>


Is there a way to retrieve the old value of a column inside an UPDATE statement without executing a SELECT first?

Something like:

update x set name='my new name' returning old name into old_name ;

(Oracle 10.2.0.3)

Thank you. Kind regards, C. Received on Tue Mar 11 2008 - 04:06:07 CDT

Original text of this message