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?
Answers were Sorted based on User's Feedback
Answer / ravin
Buddies, why are you all selecting from and updating the
tables. The question says, just two variables to be swapped
without using any extra variable and also with a single
statement.
And Ramakanth's answer is right i.e. y=x+y-(x=y) . Thats it.
^^x contains 1,2 - didn't understand though.
Is This Answer Correct ? | 13 Yes | 2 No |
declare
x number:= 1;
y number:= 2;
begin
x := x + y;
dbms_output.put_line (x); -- output 3;
y := x - y;
dbms_output.put_line (y); -- output 1;
x := x - y;
dbms_output.put_line (x); -- output 2;
end;
/
Is This Answer Correct ? | 8 Yes | 5 No |
Answer / radha sri seshu.kolla
YES SMITA I HAVE ONE DOUBT IN YOUR QUESTION. X CONTAIN 1,2
HOW ONE VARIABLE CAN HOLD TWO VALUES AT A TIME. TRY TO BE
MORE SPECIFIC IN YOUR QUESTION
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / v
yeah completely agree with u(the above person).The answer
was supposed to be in a single statement and everybody
wrote an history 4 it....hehe
no offence meant
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / senthil kumar
declare
x number:= 1;
y number:= 3;
begin
x := x + y;
dbms_output.put_line (x); -- output 4;
y := x - y;
dbms_output.put_line (y); -- output 1;
x := x - y;
dbms_output.put_line (x); -- output 3;
end;
/
Now Y got 1 and x got 3 samae way of x = 2, y =4
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sheshadri
String x="1,2";
String y="3,4";
x=(y+"$"+(y=x)).split("[$]")[0];
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / raji_4u
IF YOU WANT TO UPDATE THE TABLE,
UPDATE TABLE_NAME
SET X = Y, Y = X;
--------------------------
IF YOU WANT TO JUST DISPLAY,
SELECT Y X,X Y FROM TABLE_NAME;
ISN'T THIS SIMPLE THAN SANTHI.K DID.
Is This Answer Correct ? | 5 Yes | 7 No |
Show the two pl/sql cursor exceptions.
why sql is used as interpreter frequently rather than a compile?
How can we link a sql database to an existing android app?
How many types of indexes are there in sql?
What is pivot in sql?
Does truncate release storage space?
How to maintain the history of code changes of pl/sql?
How do you explain an index number?
What is db journal file?
What are all the different normalization?
What is pl sql block in dbms?
What are the parameter modes supported by pl/sql?