One Table having two rows with one colomn having values
Like"Male" and "Female". how to upadte these values
Like "Female" and "Male" in single update statement.
- 6 Answers
- 13819 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / murali mohan
Try this,
update testsamp1 set c=decode
(c,'MALE','FEMALE','FEMALE','MALE');
Regards,
Murali
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
How to revoke create session privilege from a user in oracle?
Can a parameter be passed to a cursor?
How many types of synonyms in Oracle?
What are group functions in oracle?
What privilege is needed for a user to create views in oracle?
What is the database name in oracle?
What are the differences between blob and clob in oracle?
How to export your connection information to a file?
What is an external table?
How to define an anonymous procedure without variables?
Explain what are the uses of rollback segment?
What is Data Dictionary Cache in Oracle?
What is an oracle wallet?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What are the most common interview questions on ETL Testing for experience?
