How to copy one column data into another column in oracle -


i want copy 1 column data column without replacing old data. example :

table-1

column1    column2   sony       sony  desc lenovo     lenovo desc  nokia      nokia desc  

i result

column 1        column2 sony            sony  desc sony  desc lenovo          lenovo desc  lenovo desc       nokia            nokia desc  nokia desc 

i have tried query not match

update table1 set column1 = column2 

if column1 has not null constraint, or if has primary key constraint, won't able insert null values. need filter out null values:

insert table1 (column1)   select column2     table1    column2 not null; 

Comments

Popular posts from this blog

c++ - Delete matches in OpenCV (Keypoints and descriptors) -

java - Could not locate OpenAL library -

sorting - opencl Bitonic sort with 64 bits keys -