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
- 16214 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / santhi k
IN ORACLE...
SELECT DECODE(X,X,Y)X,DECODE(Y,Y,X)Y FROM TABLENAME;
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
Explain the rollback statement?
What is linq to sql?
Difference between truncate, delete and drop commands?
What does subquery mean in sql?
Can you do multiple joins in sql?
Can a procedure in a package be overloaded?
How do you change a value in sql?
What is the difference between inner join and left join?
Can we use pl sql in sql server?
how can we destroy the cookie? : Sql dba
What is function and procedure?
What is the difference between python and sql?
What is prepared statement in sql?
How many commands are in sql?
what is the difference between where clause and having clause? : Sql dba
