例如你的表名是t2(a varchar2(30),b varchar2(30),c varchar2(30)),a,b,c的值是‘’,‘1’,‘3’
begin
create table t1(a varchar2(30));
insert into t1 select avg(a) from t2;
insert into t1 select avg(b) from t2;
insert into t1 select avg(c) from t2;
select avg(a) from t2; --三列的平均值
end;
/
仅供参考