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
- 17899 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 are the properties of a transaction?
Can I learn sql in a week?
What is mdf ldf and ndf?
What are the types of triggers in sql?
What is sql key?
How can a pl sql block be executed?
What is function and procedure in pl sql?
What is pragma in pl sql?
Why is sql important?
how are mysql timestamps seen to a user? : Sql dba
How does one use sql*loader to load images, sound clips and documents? : aql loader
What is the starting oracle error number?
How to create your own reports in sql developer?
What is the use of procedures?
Is sql database free?
