Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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