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
- 17739 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 application trigger?
what is the difference between nested subquery and correlated subquery?
What is sql clause?
What is the primary key?
Can we insert delete data in view?
When should I use nosql database?
Which is faster joins or subqueries?
Can triggers stop a dml statement from executing on a table?
What is flag in sql?
What is synonyms?
What is the use of function in sql?
What is pls_integer in pl sql?
Explain commit, rollback and savepoint.
What are the string functions in sql?
What is secondary key?
