Just out of curiocity, and while I am trying to learn about Row_NUMBER(), how would you code the following to do an update on the 2nd column?
select deptno, row_number() over (PARTITION BY DEPTNO order by deptno) x from emp
thx maa
> > the analytical functions are available in 8i > (..) wrap then in "execute immediate" within PL/SQL > > An update is possible in PL/SQL but it's easier to create a new table and > swap them around - unless that creates some major headaches for you.
At 08:04 PM 1/20/2004, you wrote:
Maryann
SQL> select deptno, row_number() over (PARTITION BY DEPTNO order by deptno) x from emp
2 ;
DEPTNO X ---------- ---------- 10 1 10 2 10 3 20 1 20 2 20 3 20 4 20 5 30 1 30 2 30 3 30 4 30 5 30 6
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maryann Atkinson INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).