qq_27007209
qq_27007209
2016-05-23 08:32

为什么oracle定时任务 都用 insert语句不用crate as语句

为什么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;

  • 点赞
  • 回答
  • 收藏
  • 复制链接分享

3条回答