create table tmp_t ( aa varchar2(50), bb varchar2(50) ) --insert i

How to swap the data of two columns in a table. both the
columns containing varchar values.

Question Posted / sandeep rana

Answer Posted / sandeep rana

create table tmp_t
(
aa varchar2(50),
bb varchar2(50)
)

--insert into tmp_t values('1','5')

select * from tmp_t

update tmp_t set aa=bb , bb=aa

Is This Answer Correct ?

7 Yes

12 No

Please Help Members By Posting Answers For Below Questions

What is surrogate key? : sql server analysis services, ssas

1065

What are the purposes and advantages stored procedure?

905

Difference between drill down and drill through report.

906

Is null in sql server?

955

What is recompile sql server?

1000

What is normalization? What number of normalization shapes are there?

1063

can an automatic recovery be initiated by a user? : Sql server administration

913

How to create an multi-statement table-valued function?

951

Do you know what is normalization of database? What are its benefits?

1048

How to check parameter value in stored procedure sql server?

931

What is the Main Difference between ACCESS and SQL SERVER?

1083

How to change the ownership of a schema in ms sql server?

1114

What is the report builder?

133

Why use view instead of a table?

896

What is command parameter in ssrs?

155