UPDATE Eptbl SET Sex=DECODE (Sex,'Male','Female','

One Table having two rows with one colomn having values
Like"Male" and "Female". how to upadte these values
Like "Female" and "Male" in single update statement.

Question Posted / selvaraj anna university coe

6 Answers
16095 Views
Polaris, I also Faced
E-Mail Answers

Answer Posted / selvaraj anna university coe

UPDATE Eptbl SET Sex=DECODE
(Sex,'Male','Female','Female','Male');

Is This Answer Correct ?

8 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is meant by magic query

2196

What is a schema in oracle?

1029

What is a lookup table in oracle?

985

How to lock and unlock a user account in oracle?

1120

What is the difference between truncate & delete command?

1194

How to write numeric literals in oracle?

1195

What is the sql query to concatenate column values from multiple rows in oracle?

1072

How to delete multiple rows from a table in oracle?

1074

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1945

How to use "while" statements in oracle?

1339

How to load a large xml file?

1063

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1040

How to use "for" statements in oracle?

1086

What is transaction control statement and how many types of transaction control statement in Oracle?

1176

Can we store pictures in the database and if so, how it can be done?

1056