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
- 17844 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 is the use of count (*) in sql?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
What trigger means?
What is the use of partition by in sql?
How many indexes can be created on a table in sql?
Is nosql relational?
What is on delete set null?
What is using in sql?
What is java sql connection?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
Is sql a microsoft product?
how is myisam table stored? : Sql dba
What is the starting oracle error number? What is meant by forward declaration in functions?
What is meant by user defined function?
Can we insert in sql function?
