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
- 19922 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 are the types of dbms?
Can cursors be part of a trigger body?
what are the authentication modes in sql server? How can it be changed? : Sql dba
What are hotfixes and patches?
What is schema in sql?
what are tables and fields? : Sql dba
write an sql query to find names of employee start with 'a'? : Sql dba
Mention what pl/sql package consists of?
What is query optimization in sql?
What is sql*loader?
How do I turn a list into a table?
How much ram can sql express use?
how many sql dml commands are supported by 'mysql'? : Sql dba
Does sql use python?
Should I use mbr or gpt?
