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.
- 4 Answers
- 17846 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
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
Who developed sql?
what is isam? : Sql dba
Is full outer join same as cross join?
What is bulk compiling in pl/sql.?
What is snowflake sql?
Name three sql operations that perform a sort.
What is bind variable in pl sql?
What is index example?
How to Declare Fixed Length String Value In PL SQL
how to convert numeric values to character strings? : Sql dba
How to use sql statements in pl/sql?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What is data abstraction in sql?
What is 19 null in sql?
