--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
15973 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

What is materialized view in Oracle?

1060

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2213

why dont we assign not null constraint as table level constraint.

2718

What is the difference between sharding and partitioning?

964

Explain oracle’s server parameter file.

974

Can we write dml statement in function in oracle?

1068

What is partitioned table in Oracle?

1169

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2195

How to use an explicit cursor without open statements?

1041

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1883

What privilege is needed for a user to delete rows from tables in another schema?

1048

How do I know if oracle client is installed on windows?

1003

How to create a new oracle data file?

1019

What is oracle latest version?

1080

Explain overloading. Can functions be overloaded?

965