This content has been marked as final. Show 2 replies
P.S. Sorry BluShadow, I already wrote the code before you said "try it yourself" so I'm posting it anyway.
merge into t using ( select rid, varnum from ( select rowid rid, rownum rn from t ) join ( select varnum, rownum rn from output ) using (rn) ) n on (t.rowid = n.rid) when matched then update set varnum = n.varnum;
P.P.S. I use rownum instead of row_number() because the OP said "I don't care about order".