Generate the sequence number

ntr · Post by **ntr** » Fri Dec 02, 2011 5:40 pm

Hi to all,
I strucked to generate the sequence number can any one help on this

My input Column
A
-----
3
Having value 3.
I want o/p
B
--------
4
5
I want to incrrease the number from input coumn A to Target column B.
With out using the oracle sequencer.
Can any one?

Thanks & regards

austin_316 · Post by **austin_316** » Sat Dec 03, 2011 2:00 am

how many sequence numbers do you want to generate from the input column??

ray.wurlod · Post by **ray.wurlod** » Sat Dec 03, 2011 4:05 am

What triggers the generation of the sequence number? If it's every row, just add @INROWNUM to the starting value.

ntr · Post by **ntr** » Sun Dec 04, 2011 6:46 pm

HI ,
Thanks
I got the solution by using @INROWNUM.

Thanks & regards,