update tbl_name set (a,b) = (select b,a from tbl

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 / apsar

6 Answers
16073 Views
Polaris, I also Faced
E-Mail Answers

Answer Posted / apsar

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

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to pass parameters to procedures?

1040

What are the execution control statements?

1073

Where are the settings stored for each instance in oracle?

1111

Can we connect to ORACLE db using Windows Authentication?

1265

How does one get the view definition of fixed views/tables?

1027

Can you create a synonym without having a table?

1046

What are the system predefined user roles?

1048

State and explain about oracle instance?

1003

What is a tns file?

1003

How do I call oracle stored procedures that take no parameters?

1125

What are dml statements in oracle?

1098

How to update values in a table in oracle?

1030

How would you begin to troubleshoot an ORA-3113 error?

2086

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1037

How do I limit the number of rows returned by an oracle query after ordering?

1175