Re: Sorting a column
From: digory <digory_at_gmx.net>
Date: Thu, 7 Aug 2008 01:48:55 -0700 (PDT)
Message-ID: <3823ec17-b178-4b79-a428-af148ec20633@f36g2000hsa.googlegroups.com>
Date: Thu, 7 Aug 2008 01:48:55 -0700 (PDT)
Message-ID: <3823ec17-b178-4b79-a428-af148ec20633@f36g2000hsa.googlegroups.com>
I just tried the following
UPDATE T
SET pos = DENSE_RANK () OVER (ORDER BY name)
Unfortunately, this does not work because Oracle does not allow analytic functions in the SET clause. Received on Thu Aug 07 2008 - 03:48:55 CDT