Skip to Main Content
Forums

SQL & PL/SQL

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!

update different values in same column

jaijeevaJun 7 2016 — edited Jun 7 2016

Hi,

     Pls help me out resolve this issue.I just need to update a column based on same column values.Actually they are giving multiple values in one array based on same column  values in another array.

create table t1

(id number(10),

display_order_id number(10))/

DISPLAY_ORDER_id        DISPLAY_ORDER_id

38                                            40

39                                            42

40                                            39

42                                            38

based on above 1st Display_order_id we want to update like 2nd display_order_id.

Thanks&Regards

jai
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 5 2016
Added on Jun 7 2016
1 comment
553 views