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
- 16225 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what is recursive stored procedure? : Sql dba
Define sql delete statement.
What are conditional predicates?
What is difference between inner join and cross join?
How to sort the rows in sql.
What does sign mean sql?
What is an ndf file?
What is clustered index sql?
What is data control language (dcl)?
Can we debug stored procedure?
What are basic techniques of indexing?
What mean sql?
What is the current version of postgresql?
What is a natural join sql?
How do we use distinct statement? What is its use?
