how to copy column

[krishhhna]

hi this is krishhhna,

plzz tell me how to copy one column data into another column ,the both columns are in the same table..what is the query

[krishhhna]

copy data into amother column

hi,
this is krishna..

how to copy one column data into another column ,both the columns are in same table..
plzzzz give me a replyyyyy

[debasisdas]

simply use update

[CODE=oracle]update tablename set col1=col2 [conditions if any];[/CODE]

[debasisdas]

please do not post duplicate posts

Threads merged.

MODERATOR.

[holdingbe]

hi,
this is krishna..

how to copy one column data into another column ,both the columns are in same table..
plzzzz give me a replyyyyy

Hi,
insert into table_name(colu mn2)
select column1
from table_name;

[nramrits]

Hai Try This Query

Update Table_name Set Column_name1=co lumn_name2;