oracle计算列

--创建一个包含计算列的表
create table testcopy(fid number,fstring1 varchar2(200),fstring2 varchar2(200),fstringadd varchar2(400) GENERATED ALWAYS AS (fstring1||fstring2))
--插入数据
insert into testcopy(fid,fstring1,fstring2) values(1,'my name is ','lilei')
--数据情况
select * from testcopy

--创建新表
create table testcopy2(fid number,fstring1 varchar2(200),fstring2 varchar2(200),fstringadd varchar2(400) GENERATED ALWAYS AS (fstring1||fstring2))
--插入数据
insert into  testcopy2(fid,fstring1,fstring2,fstringadd ) select fid,fstring1,fstring2,fstringadd from  testcopy