Data Base Issues - Oracle EBS R12
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment