Re: How to Update a UNIQUE field ?

reference the sequence like my_seq.nextval. this can be done in sqlldr or as a trigger.

if those are not viable options, then provide some more details that will allow people to help you.

R Chin wrote:
>
> MY_TAB gets loaded daily, one UNIQUE-indexed field COL_UNIQ does NOT get
> values in the loading....
> I need to populate this field with unique values....
>
> How can I UPDATE this field with (where is null) values (from a SEQUENCE) ?
>
> Thanks
>
> Robert
Received on Tue Apr 16 2002 - 11:39:38 CDT