--创建一个包含计算列的表
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
--创建一个包含计算列的表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')--数据情况selec.