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
- 17732 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 are the three forms of normalization?
What do you mean by stored procedures?
Explain select statements in sql?
How do I install sql?
What is a table?
How to create a menu in sqlplus or pl/sql?
When you have to use a default "rollback to" savepoint of plvlog?
Explain the significance of the & and && operators in pl sql.
How do you modify a column in sql?
What is localdb mssqllocaldb?
What is a field in a database?
How to change the order of columns in Oracle SQL Plus ?
How do you explain an index number?
What is the difference between Union and Union all. Which is faster.
What are the types of triggers in sql?
