| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: update takes to long
On Fri, 16 Feb 2007 06:12:22 -0800, andersleffler wrote:
> UPDATE a
> SET (sortorder) = (SELECT COUNT (sortorder)
> FROM a b
> WHERE b.PATH <= a.PATH)
Update a
set sortorder = row_number() over (order by path);
-- http://www.mladen-gogala.comReceived on Fri Feb 16 2007 - 11:08:05 CST
 |
 |