Re: a trigger to increment key ????

Why don't you use a sequence to "increment" keys?

If you're keys are integers, create a sequence and access it:

select seq_name.nextval ....

In article <8nubn9$cf5$2_at_wanadoo.fr>,
  "Jerome Carpene" <jerome.carpene_at_aliso.com> wrote:
> Well I intend to use a trigger to compute the new row key value, but
 then
> that value will be needed !
> Is it possible to get it back ????
>
> otherwise how to have that kind of auto increment key ?
>
> Thanks for your help :))
>
> --
> Jérôme CARPENE
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Aug 22 2000 - 13:14:10 CDT