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

Sql server reporting services vs. Crystal reports.

can any body tell me how to know the password of current user in sql server

1573

What is the difference between delete and truncate statements?

564

What are the joins in sql server? : sql server database administration

535

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

497

What is service broker?

578

What is row_number () and partition by in sql server?

517

Explain unique key in sql server?

534

Do you know query execution plan?

582

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

3368

How to check table values in sql server?

527

How do I know if localdb is running?

507

How to select some specific rows from a table in ms sql server?

565

What happens if an integer is too big for int date type?

569

How to configure and test odbc dsn settings?

567