Calling oracle sequence

sateeshbabu · Post by **sateeshbabu** » Tue Feb 26, 2008 1:00 am

Hi,

We have a oracle sequence which has to be used for three target table(Oracle) columns,How could we call oracle sequence and pass the sequence generated value to them.

Thanks for your time

Thanks,
Sateesh

ray.wurlod · Post by **ray.wurlod** » Tue Feb 26, 2008 2:34 am

Very easily. And if you search the forum you will find that that question has been answered lots of times - sometimes with examples - already.

sateeshbabu · Post by **sateeshbabu** » Tue Feb 26, 2008 5:43 am

Hi Ray,

Thanks for your suggestion and i got to know how to call sequence value in target database,But the thing is that i want to generate the unique value for all the three target table columns ,How could i achieve this.

In my target insert query i am calling oracle sequence like seq.nextval.

Thanks,
Sateesh

ray.wurlod · Post by **ray.wurlod** » Tue Feb 26, 2008 5:57 am

Three sequences.

Same as you would do it if you didn't have DataStage.