Update table_name Set gender = decode(gender,'M','F',

Interchange the value of a column Gender in a table where
values are Male and Female. So, where the value is Male, it
should changed to Female and Female to Male.

Question Posted / sushma s

4 Answers
20056 Views
Cap Gemini, IBM, I also Faced
E-Mail Answers

Answer Posted / sushma s

Update table_name
Set gender = decode(gender,'M','F','M');

Is This Answer Correct ?

8 Yes

9 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to check if a column is nullable before setting to nullable?

1173

What is bulk compiling in pl/sql.?

1186

How many row comparison operators are used while working with a subquery?

1069

what is the use of double ampersand (&&) in sql queries?

1222

What is a database trigger?

1126

What does (*) mean in sql?

994

What is sql profiling in oracle?

1125

what is the difference between sql and t-sql? : Transact sql

1130

What are analytic functions in sql?

1067

Is left join faster than join?

1094

How to disable a trigger name update_salary?

1307

Is the primary key an index?

1073

What is a .db file?

1039

what is an extent ? : Sql dba

1155

What is dense_rank in sql?

1034