概述:
Oralce在begin 和end 之间创建数据表时,会出现如标题的错误。
语句如下:
begin
create table create table studentinfobackup as
select * from studentinfo
end ;
create table create table studentinfobackup as
select * from studentinfo
end ;
按下F8进行执行语句会出现如下错误
解决办法:
begin
Execute immediate ' create table studentinfobackup as select * from studentinfo ' ;
end ;
Execute immediate ' create table studentinfobackup as select * from studentinfo ' ;
end ;