Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to update to column with the same sequence number?

Mr.D.Feb 13 2015 — edited Feb 13 2015

Hi,

I need to update 2 column of the same table with the same sequence number.

update table

  set column1=seq.nextval(),

        column2=seq.nextval();

Can this works?

Database version 11.2

Regards

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 13 2015
Added on Feb 13 2015
6 comments
3,028 views