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
15762 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

What is a Garbage Collection? and what is full recursive Garbage collection?

2846

Please explain joins in oracle?

1009

What is the usage of merge statement?

1097

Explain an index?

1095

How to rebuild an index in oracle?

976

> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

1983

What is a nvl function?

958

How to view the tablespaces in the current database?

929

What is a data lock in oracle?

1018

What is a data dictionary and how can it be created?

1057

is there a tool to trace queries, like profiler for sql server?

1078

Difference between the “verify” and “feedback” command?

1309

What is an oracle and why it is used?

1080

What are the benefits of ordbms?

1025

How many types of synonyms in Oracle?

1066