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 a derived table?

991

What is database replication?

1210

Can you name a few encryption mechanisms in sql server?

992

How many types of database relationship in sql server?

1103

What are pessimistic lock and optimistic lock?

1141

What is snapshot report?

172

How to test values returned by a subquery with the in operator?

1253

Explain Reporting Life Cycle?

132

How to delete an existing row with delete statements in ms sql server?

1151

You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

158

What is “asynchronous” communication in sql server service broker?

1080

What is deploy, process and build? : sql server analysis services, ssas

1156

How to defragment table indexes?

1038

What are the advantages of paper records?

1012

What is the purpose of a table?

995