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 / parli jain

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

Answer Posted / parli jain

Update table_name
set Gender = decode (Gender, 'M', 'F', 'F,'M')
where Gender In ('M','F');

Is This Answer Correct ?

29 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Does truncate free space?

948

What is rank dense_rank and partition in sql?

977

Is left join same as join?

939

What is dba in sql? : SQL DBA

999

What is dbo in sql?

921

What is pessimistic concurrency control? : Transact sql

1026

What is a sql instance vs database?

1038

What are the three forms of normalization?

996

Advantages and disadvantages of stored procedure?

1061

Can ddl statements be used in pl/sql?

1070

What is cte?

924

Explain the difference between triggers and constraints?

922

What is rename command in sql?

953

Is pl sql and postgresql same?

1058

Why do we use subquery?

944