Populating a column with sequence values
I have a table with 4000 records and this table doesn't have a primary key. Now i've added a column to this table which should be the future primary key of this table.
Now i've created a sequence. How can i populate the values generated by this sequence to the newly created empty column with all my 4000 rows remaining intact?
I had a column called created_time which gets populated with sysdate every time a row was inserted. Can i insert the sequence values based on the chronological order of created_time column?