Assume that the sample table is as below X Y ------------ 1 3 2 4 Up

there are 2 variables called x and y ,x contains 1,2 and y
contains 3,4 we have to swap the values from x to y and y
to x with out using dummy variables and it can be done only
by using a single statement ? how?

Question Posted / nanne saheb c

12 Answers
19869 Views
Oracle, I also Faced
E-Mail Answers

Answer Posted / nanne saheb c

Assume that the sample table is as below
X Y
------------
1 3
2 4

Update sample set
X=decode(X,1,3,2,4),
Y=decode(Y,3,1,4,2);

(OR)
Update sample set
X = (case when 1 then 3
when 2 then 4
end),
Y = (case when 3 then 1
when 4 then 2
end);

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Define select, insert, create, delete, update, drop keywords

1044

what is sub-query? : Transact sql

1097

What is a common use of group by in sql?

1048

What packages(if any) has oracle provided for use by developers?

5807

What does fetching a cursor do?

1083

What version is sql?

1022

What is not in sql?

942

What is orm in sql?

1044

what are the types of join and explain each? : Sql dba

1037

What is sql indexing?

1008

What is pl sql collection?

962

Is postgresql a server?

1046

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2165

Where can I learn sql for free?

981

Explain the update statement in sql

983