Skip to Main Content
Forums

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!

Help in Updating all Table Rows with sequence

AshishKumarMishraJun 13 2013 — edited Jun 13 2013

Hi All,

I have a table in data with name Report_Status, now we added a new column[Batch_ID] in the table. The new column takes a value from a sequence. Can somebody tell me a normal SQL query or procedure to update each row one by one of existing table from the sequence value? We can not delete the existing data, we need to add the batch id for each record.

example Sequence name : Report_Status_Batch_ID_SEQ

table name Report_Status and column name Batch_ID

Thanks for your time to help me out.

Regards,

Ashish
This post has been answered by AshishKumarMishra on Jun 13 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 11 2013
Added on Jun 13 2013
#general-database-discussions, #update, #with
2 comments
19,803 views