Numbers in Sequence

Hi ppl....

i hav the foll: table in oracle... a sample table with just two columns will look lyk this:

Name                  SEQ_number
  A                           31
  A                           33
  A                           37
  B                           2
  B                           3
  B                           6
  C                           4
  C                           7
  C                           8

the prob is that i need the numbers tfor each name to be in sequence starting from 1...
to look lyk the foll:

Name                  SEQ_number
  A                           1
  A                           2
  A                           3
  B                           1
  B                           2
  B                           3
  C                           1
  C                           2
  C                           3

Plzzz help...
thx in advance :) Received on Fri Sep 15 2006 - 03:44:40 CDT