Answer / murali mohan

Try this,


update testsamp1 set c=decode
(c,'MALE','FEMALE','FEMALE','MALE');


Regards,
Murali

Answer / selvaraj anna university coe

UPDATE Eptbl SET Sex=DECODE
(Sex,'Male','Female','Female','Male');

Answer / brahma prakash

Murali your answer is not running on postgres database

Answer / manikanta

'DECODE' is not a recognized built-in function name in sql
server

Answer / hitendra yadav

--Try this

UPDATE Eptbl
SET Sex= CASE WHEN SEX='Male'
THEN 'Female'
ELSE 'Male'
END;

Answer / apsar

update tbl_name set (a,b) = (select b,a from tbl_name where a='Male');

How to get execution path reports on query statements?

0 Answers  

Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz

2 Answers  

What is a cognitive schema?

0 Answers  

Explain the difference between a procedure and a function?

0 Answers  

What is integrity and what is constraint??Explain with example

0 Answers   Google,

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

0 Answers   IBM,

Explain cascading triggers.

0 Answers  

Define 'view' advantage ?

2 Answers   AZTEC, TCS,

How view is different from a table?

0 Answers  

How to assign values to data fields in record variables?

0 Answers  

can we pass two out parameters at a time in function?please answer to my question

3 Answers   Wipro,

What is the difference between substr & instr functions?

0 Answers