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
- 19910 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 is the difference between char and varchar data types? : Sql dba
Is hadoop a nosql?
What is difference sql and mysql?
What are stuff and replace function?
Is left join inner or outer?
What are the possible values that can be stored in a boolean data field?
What type of database is sql?
How would you pass hints to the sql processor?
How do I access sql anywhere database?
How to write pl sql program in mysql command prompt?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
How delete a row in sql?
Who is the owner of mysql database?
Differentiate between sga and pga.
What are the advantages of normalization?
