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 populate an attribute field with a sequence?

615365Mar 18 2008 — edited Mar 18 2008
Hi,

I have a table with 5000 records in it, already populated with data. I created an attribute field called Ref. Type is not matter, integer or text.

Now i want to populate this field using oracle sequence function.

I know to create a sequence, however; i don't know how to grab a number from a sequence and insert it to my Ref column for 5000 rows in one single step.

Regards.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 15 2008
Added on Mar 18 2008
4 comments
453 views