Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to update 2 records simultaneously on a self-join?

Re: How to update 2 records simultaneously on a self-join?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 27 Aug 2006 23:43:50 +0200
Message-ID: <td44f2155h3nsovo7j8t36gfedtfiocd5m@4ax.com> 





On 27 Aug 2006 07:18:28 -0700, "sidey" <sideyt_at_hotmail.com> wrote:



>  IS there any way to update an Oracle table using pairs of records,

>update both records simultaneously and preferably proceed in descending

>order on fieldC?





Oracle happens to be a Relational Database Management System.
In RDBMSes all operations occur on *sets*
By mathematical definition set have *no order*
So either you should go back to a flat file system, or to punch cards.


--
Sybrand Bakker, Senior Oracle DBA


Received on Sun Aug 27 2006 - 16:43:50 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US