Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Numbers in Sequence

Re: Numbers in Sequence

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 15 Sep 2006 06:40:42 -0700
Message-ID: <1158327640.32878@bubbleator.drizzle.com>


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
Received on Fri Sep 15 2006 - 08:40:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US