Re: Numbers in Sequence

Reiro wrote:
> 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 :)
>

ORDER BY clause or rebuild your table as an IOT.

-- 
Puget Sound Oracle Users Group