Try this, update testsamp1 set c=decode (c,'MALE','FEM

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.

Question Posted / murali mohan

6 Answers
15770 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

Please Help Members By Posting Answers For Below Questions

How do we represent comments in oracle?

1003

What is rich query?

931

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1900

What is a data lock in oracle?

1019

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2074

Explain about achiever in sql?

981

How to define default values for formal parameters?

985

What are the most common interview questions on ETL Testing for experience?

1079

What is set operator oracle?

923

How to check your oracle database 10g xe installation?

928

Explain self joins in oracle?

951

How to select some rows from a table in oracle?

1009

What is a nvl function?

958

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1047

What is literal?

960