Home » SQL & PL/SQL » SQL & PL/SQL » Updating data within same table
Updating data within same table [message #38128] Fri, 22 March 2002 09:31 Go to next message
Tony
Messages: 190
Registered: June 2001
Senior Member
The data in column a should be in column b and the data in column b should be in column a.

Is there a quick procedure that I can run to do this switch?

Thanks

Report message to a moderator

Re: Updating data within same table [message #38129 is a reply to message #38128] Fri, 22 March 2002 10:51 Go to previous message
Tim
Messages: 49
Registered: October 2000
Member
Unless I am misunderstanding the problem, the simple statment of:

UPDATE tblname
SET a = b,
b = a;

should switch the two columns.

Report message to a moderator

Previous Topic: process
Next Topic: SQL ORA-00923
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 07:45:47 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.