OraFAQ Forum: SQL & PL/SQL » Swapping in Sql

Home » SQL & PL/SQL » SQL & PL/SQL » Swapping in Sql

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Swapping in Sql [message #11074]

Thu, 04 March 2004 15:21

k. sasikumar
Messages: 6
Registered: September 2003

Junior Member

How to swap two columns in Sql (for Updating the
data on the same table)?

Report message to a moderator

Re: Swapping in Sql [message #11075 is a reply to message #11074]

Thu, 04 March 2004 15:25

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

Pretty straightforward:

SQL> select * from t;
 
        C1         C2
---------- ----------
         1          2
         3          4
 
SQL> update t set c1=c2, c2=c1;
 
2 rows updated.
 
SQL> select * from t;
 
        C1         C2
---------- ----------
         2          1
         4          3

Report message to a moderator

Previous Topic:	Urgent
Next Topic:	HOW CAN I PUT CONSTRAINTS IN A TABLE THAT HAVE EXITS IN A DATABASE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 17:19:56 CDT 2024