Re: How to link sequences to fields in Designer6.0

[Quoted] You can't. sequences are not bound to any particular table, so you could use [Quoted] one sequence across multiple tables. You need to populate your column in a pre-insert trigger using
select <sequencename>.nextval into
<key_column>
from dual;

Hth,

Sybrand Bakker, Oracle DBA

"Alvaro Palma Aste" <apalmanospam_at_cec.uchile.cl> wrote in message news:8lqseq$knt$2_at_localhost.localdomain...
> How can I link a sequence to one field of a table in Designer 6.0. I can't
 find any
> option where input ORACLE sequence associated to the field
>
> Thanks for your answer
>
> Regards from Chile
>
> --
> Atte
>
> Álvaro Palma Aste
> Grupo de Ing Biomédica
> U. de Chile
> apalma_at_cipres.cec.uchile.cl
>
Received on Fri Jul 28 2000 - 00:00:00 CEST