How to update a rows with opposite gender in Sql?

In Emp table there is a column which consists of gender (Male or Female) ? How should one
Can update the Values of Male to Female and Female to Male with a single query ?

Questions by raiyaans   answers by raiyaans

Showing Answers 1 - 10 of 10 Answers

Anamika Mehera

  • Aug 5th, 2014

Select Decode(gender,m,f,f,m,null) from table

  Was this answer useful?  Yes


  • Aug 25th, 2014

Above code should be like this..

  1. SELECT Decode(:gender,m,female,f,male,NULL) FROM dual;

  Was this answer useful?  Yes


  • Sep 12th, 2014

Here the question is how to update the Table not how you show the table

  Was this answer useful?  Yes

Subalakshmi R

  • Sep 24th, 2014

There should be some additional condition to be applied against another column apart from the gender column. otherwise, it is not possible.

  Was this answer useful?  Yes

sagar bodala

  • Nov 3rd, 2014

using decode like Decode(M,F,M) ,( if in case the column values are stored in M,F format)

  Was this answer useful?  Yes


  • Nov 11th, 2014

The above question is update the rows,not for display purpose.we required to make select statement in update query.

  Was this answer useful?  Yes


  • Nov 13th, 2014


  Was this answer useful?  Yes


  • Nov 22nd, 2014

i need to update in the table not to select can u guys show me how to change directly in the database

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions