可以,但是要用动态sql
declare
tablename varchar2(200);
str varchar2 varchar2(2000);
begin
tablename:='aaa';
str:='insert into '||tabelname||' select * from user';
execute immediate str;
end;
declare
tablename varchar2(200);
str varchar2 varchar2(2000);
begin
tablename:='aaa';
str:='insert into '||tabelname||' select * from user';
execute immediate str;
end;
str:='insert into '||tabelname||' select * from user';
execute immediate str;要了解 execute immediate str;
tablename是动态生成的啊,这个算个用java实现容易,在存储过程里不太容易吧,因为实际到字符的判断,还要考虑中文字符。谢谢!