Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 16087 Views
- Polaris, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / murali mohan
Try this,
update testsamp1 set c=decode
(c,'MALE','FEMALE','FEMALE','MALE');
Regards,
Murali
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / selvaraj anna university coe
UPDATE Eptbl SET Sex=DECODE
(Sex,'Male','Female','Female','Male');
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / brahma prakash
Murali your answer is not running on postgres database
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / hitendra yadav
--Try this
UPDATE Eptbl
SET Sex= CASE WHEN SEX='Male'
THEN 'Female'
ELSE 'Male'
END;
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / apsar
update tbl_name set (a,b) = (select b,a from tbl_name where a='Male');
| Is This Answer Correct ? | 0 Yes | 0 No |
what is the difference between first normal form & second normal form?
What are the attributes of the cursor?
What is meant by an index?
What is meant by joins?
What happens if variable names collide with table/column names?
how to get last monday of a month?
Without giving condition how to retrieve the unmatched records from table.
Explain the different normalization forms?
Explain drop constraint oracle?
What is the order of defining local variables and sub procedures/functions?
How to load data from external tables to regular tables?
What is rowid and rownum in oracle?
Oracle General 
