为什么oracle定时任务 都用 insert语句不用crate as语句:
一、用insert
create or replace procedure ACCESS_PROD is
begin
execute immediate 'truncate table access_prod_inst';
insert into access_prod_inst select* from access-prod_inst@crmbm;
二、用select as
create or replace procedure ACCESS_PROD is
begin
drop tabale ACCESS_PROD;
create table access_prod_inst as select* from access-prod_inst@crmbm;