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!

Interchange values from one row with another row

470436Feb 27 2010 — edited Feb 27 2010

Dear Oracle Guru's

While Migrating data from legacy system, there was a confusion and data in two columns got jumbled

Ex The data should be like this
Custcode leaseno
1034 A234
1035 A235
1036 A236

whereas the table has data like this

Custcode leaseno
1034 A235
1035 A234
1036 A237
1037 A236

How do we swap values between two rows

Kindly guide me on this

With Warm Regards
ssr

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 27 2010

Added on Feb 27 2010

3 comments

3,607 views