Oracle触发器的问题

  使用PL/SQL Developer开发Oracle触发器时,明明脚本里面的是小写字母,为啥有个触发器到了数据库里确变成大写的了,而其它的触发器确没有呢?

  脚本:

create or replace trigger TRIGGER_AFTER_SALE
before insert on DICT_AFTER_SALE
for each row
begin
select SEQ_AFTER_SALE.nextval into :new.ENGINEERID from dual;
end;

  写入后脚本:

CREATE OR REPLACE TRIGGER TRIGGER_AFTER_SALE
before insert on DICT_AFTER_SALE
for each row
begin
select SEQ_AFTER_SALE.nextval into :new.ENGINEERID from dual;
end;

  可以看到create or replace trigger变成了CREATE OR REPLACE TRIGGER,这到底是为什么呢?

posted on 2012-11-22 21:18  onedime  阅读(330)  评论(0编辑  收藏  举报