使用PL/SQL Developer开发Oracle触发器时,明明脚本里面的是小写字母,为啥有个触发器到了数据库里确变成大写的了,而其它的触发器确没有呢?
脚本:
create or replace trigger TRIGGER_AFTER_SALEbefore insert on DICT_AFTER_SALEfor each rowbeginselect SEQ_AFTER_SALE.nextval into :new.ENGINEERID from dual;end;
写入后脚本:
CREATE OR REPLACE TRIGGER TRIGGER_AFTER_SALEbefore insert on DICT_AFTER_SALEfor each rowbeginselect SEQ_AFTER_SALE.nextval into :new.ENGINEERID from dual;end;
可以看到create or replace trigger变成了CREATE OR REPLACE TRIGGER,这到底是为什么呢?