declare IsTable INTEGER:=0;
begin
select count(*) into IsTable from DBA_TABLES where table_name='NEDW_M_B_ADSL_D';
if IsTable=0 then
create table NEDW_M_B_ADSL_D as
select * from NEDW_M_B_ADSL_D@lnzd where rownum<=10;
else
insert into NEDW_M_B_ADSL_D select * from NEDW_M_B_ADSL_D@lnzd where rownum<=10;
end if;
end;报错,
ORA-06550
PLS-00103 : 出现符号“crerate”在需要下列之一时......请问如何解决?
select * from NEDW_M_B_ADSL_D@lnzd where rownum<=10'