IF YOU WANT TO UPDATE THE TABLE, UPDATE TABLE

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

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

Answer Posted / raji_4u

IF YOU WANT TO UPDATE THE TABLE,

UPDATE TABLE_NAME
SET X = Y, Y = X;

--------------------------
IF YOU WANT TO JUST DISPLAY,

SELECT Y X,X Y FROM TABLE_NAME;

ISN'T THIS SIMPLE THAN SANTHI.K DID.

Is This Answer Correct ?

5 Yes

7 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Determine if oracle date is on a weekend?

981

What is dynamic query?

913

Explain the the delete statements in sql?

977

how to see the create table statement of an existing table? : Sql dba

946

Is truncate ddl or dml?

942

Can there be 2 primary keys in a table?

951

what is auto increment? : Sql dba

964

Is there any restriction on the use of union in embedded sql?

1099

What is trigger point?

949

What is the size of partition table?

990

What is an escape character in sql?

979

What is procedure explain with program?

949

what happens if null values are involved in expressions? : Sql dba

1000

Which is better join or inner query?

960

Can we perform dml in function?

1014