y=x+y-(x=y)

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 / ramakanth

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

Answer Posted / ramakanth

y=x+y-(x=y)

Is This Answer Correct ?

6 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What schema means?

887

How do sql triggers work?

1035

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

4008

What is AUTH_ID and AUTH_USER in pl/sql ?

2186

How does sql profiler work?

1016

Is postgresql a nosql database?

1155

What is set transaction?

1035

What is java sql driver?

1112

What is sql*plus?

1072

Can a foreign key be a duplicate?

906

What is a unique key?

1051

Is pl sql different from sql?

992

what is the difference between $message and $$message? : Sql dba

995

Explain two easy sql optimizations.

1008

How can you create an empty table from an existing table?

1078