Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 12 Answers
- 20306 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
What is the difference between union and union all command?
explain advantages of innodb over myisam. : Sql dba
how to use in conditions? : Sql dba
How do I turn a list into a table?
What is trigger and stored procedure in sql?
What is rownum?
What is a constraint? Tell me about its various levels.
What is the use of double ampersand (&&) in sql queries? Give an example
What is self-join and what is the requirement of self-join?
is it possible to pass an object or table to a procedure as an argument?
define sql delete statement ? : Sql dba
What are the dml statements?
Can we use join in subquery?
How many sql are there?
How do you know if a relationship is 2nf?
