Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 20073 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
What does desc stand for?
what is oltp (online transaction processing)? : Sql dba
Does sql view stored data?
What is an emotional trigger?
What is the difference between left outer join and left join?
What are different types of sql commands?
What is sharding in sql?
What are the events on which a database trigger can be based?
What is the use of <> sql?
How do I remove all records from a table?
define join and explain different type of joins? : Sql dba
How do I create a sql database?
What is schema in sql?
Why procedure is used in sql?
Explain some predefined exceptions.
