You can use a "before insert" trigger to populate your sequence column.
Create a sequence. Create a table trigger that gets the value from the
sequence and assign the sequence as a column value.



"luis" <oracledba-ezmlmshield-x99462741.[Email address protected] wrote on
05/31/2006 07:18:48 AM:

> G's
>
> I will try and make sense, but cannot guarantee it.
>
> I want to have a unique incremental indentifier on records being
inserted.
> For every insersion there should be a column with this indentifier and
as a
> record is inserted this sequence to kick in and insert the it's value
into
> the table.
>
> How can I relate a sequence to a table?
>
> Am I going about it the right way?
>
> Thanks,
> Luis
>
>
> This communication is intended for the addressee(s) only.
> Please notify the sender if received in error. Internet email
> is not to be treated as a secure means of communication.
> Cheshire Constabulary monitors all Internet and email activity
> and requires it is used for official communications only. Thank
> you for your co-operation.
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>


--
This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.

Oracle LazyDBA home page