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
- 17861 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
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
What is sql select statement?
What is left join in postgresql?
Explain correlated query work?
What is difference between sql and oracle?
How subquery works in sql?
What is the process of debugging?
Should I use mbr or gpt?
What is a mutating table and a constraining table?
how would you get the current date in mysql? : Sql dba
Is truncate ddl or dml?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
What is difference between sql function and stored procedure?
Is it important to partition hard disk?
How do I view an execution plan in sql?
