Skip to Main Content

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!

how to swap two values in sql with out using third variable ?

1033266Jun 16 2016 — edited Jun 16 2016

Hi,

How to swap two numbers in sql with out using third variable i.e i have table a in that columns number1 and number2 data will be 1 ,2 in table then how can we swap it

Thanks

Raghu

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 14 2016
Added on Jun 16 2016
5 comments
1,888 views