Thursday 24 March 2016

Copy data from one column to another in oracle table

http://dbissues.blogspot.com/2016/03/copy-data-from-one-column-to-another-in.html

create table abc
(Num VARCHAR2 (10),
Address varchar2 (10));

select * from abc
for update

insert into abc
values (2,null);

update abc set ADDRESS = NUM;

No comments:

Post a Comment