Try this, update testsamp1 set c=decode (c,'MALE','FEM

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 / murali mohan

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

Answer Posted / murali mohan

Try this,

update testsamp1 set c=decode
(c,'MALE','FEMALE','FEMALE','MALE');

Regards,
Murali

Is This Answer Correct ?

8 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to commit the current transaction in oracle?

1180

What is user managed backup in Oracle?

1204

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1975

What is literal?

1062

What are the differences between date and timestamp in oracle?

1095

How to write a query with an inner join in oracle?

1094

Explain the use of grant option in imp command.

1078

How to create an initialization parameter file?

1106

How to concatenate two text values in oracle?

1156

What is Virtual Private Database in Oracle?

1150

What are the major difference between truncate and delete?

1134

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5477

How to rename an index?

1124

What does sharding mean?

1052

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

1991