--Try this UPDATE Eptbl SET Sex= CASE WHEN SEX='Male'

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 / hitendra yadav

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

Answer Posted / hitendra yadav

--Try this

UPDATE Eptbl
SET Sex= CASE WHEN SEX='Male'
THEN 'Female'
ELSE 'Male'
END;

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to bring a tablespace offline?

1074

How would you best determine why your MVIEW couldnt FAST REFRESH?

1899

What is the meaning of recursive hints in oracle?

1051

How to increment dates by 1 in oracle?

1105

Can the query output be sorted by multiple columns in oracle?

1002

Explain the use of online redo log files in oracle.

1044

How are extents allocated to a segment?

1139

Explain overloading. Can functions be overloaded?

1011

What is meant by a deadlock situation?

1118

Explain what are synonyms used for?

1049

What is the relation of a user account and a schema?

1139

What is the difference between formal parameters and actual parameters?

1097

How do I know if oracle is installed on windows?

942

Please explain joins in oracle?

1070

Will you be able to store pictures in the database?

1132