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

what is cursor. write example of it. What are the attributes of cursor.

1336

What is trigger in pl sql?

972

Why are indexes and views important to an organization?

917

what is 'mysqlshow'? : Sql dba

986

Does truncate free space?

966

What is data profiling in sql?

1034

Which tcp/ip port does sql server run?

973

How to get list of all tables from a database?

1125

How do I partition a table in sql?

1075

Why triggers are used?

950

How to get help at the sql prompt?

1082

What is an example of translating a date into julian format?

1066

how to create a test table in your mysql server? : Sql dba

967

What is data control language?

962

Which are sql * plus commands?

1074