Hi All, Could you please help me with this asap.
I have a table as below: (all the value in target_key is null) source_key target_key 20 1 31 8 This is what I need to acheive: source_key target_key 1 100 8 101 20 102 31 103 Need to update target_key with a series on number after sorting the source_key. I generated the number 100 - 103 using the query below and have collected into a collection. *But facing problem to update with order by * as .. TYPE ntable_key_list_type IS TABLE OF NUMBER; v_key_list ntable_key_list_type; ... begin .. .. *Select Rownum bulk collect into v_key_list >From dual Connect By Rownum <= v_rec_cnt;* forall i in v_key_list.first .. v_key_list.last update ....; end Please suggest asap. Thanks in advance G -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
