Sorting update?

From: Thorsten Koch <torsti_engy_at_my-deja.com>
Date: Tue, 21 Sep 1999 17:55:08 GMT
Message-ID: <7s8gpk$mnb$1@nnrp1.deja.com>

Hi folks!

Let there be table EMP with
POS NUMBER
NAME VARCHAR2
SAL NUMBER and the data
POS NAME SAL
----- ------ -----

1       A       1000
2       C        500
3       B        700

Now I want to update the table in a way that its sorted by salaries, so that it looks like this:

POS NAME SAL
----- ------ -----

1       C        500
2       B        700
3       A       1000

That is, I would like to have an update-statement like

update emp
set pos=(select rownum

         from emp
         order by sal);

Unfortunately, it is not possible to use "order by" in an update statement.

Can someone advise me how to perform this task? I would be glad to receive a few different solutions, because not all solutions may fit to my special application.

Many thanks,

Thorsten

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Sep 21 1999 - 12:55:08 CDT