IN ORACLE... SELECT DECODE(X,X,Y)X,DECODE(Y,Y,X)Y FROM TABLENAME;

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 / santhi k

12 Answers
19408 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

Please Help Members By Posting Answers For Below Questions

What is full form of rtm?

953

what is meant by nl2br()? : Sql dba

975

What does pragma mean?

975

Why sql query is slow?

931

What is rollback?

1038

What are the advantages of sql?

1008

what is msql? : Sql dba

943

What is record data type?

861

What is an escape character in sql?

982

What is the difference between local and global temporary table?

989

What is integrity in sql?

981

What is normalisation in sql?

1005

Why do we create views in sql?

1055

What is the main difference between sql and pl/sql?

1028

What can sql server reporting services do?

1057