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>


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

Original text of this message