Toad 13.0.353
this is Toad generated script (from grid). why trigger part "before insert" is always differently formated in generation?
CREATE OR REPLACE TRIGGER TOOLS.COMM_VERSIONS_TGBI **BEFORE INSERT**
ON "TOOLS"."COMM_VERSIONS"
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
:new.NAME := UPPER(ltrim(rtrim(:new.name)));
:new.PREFIX := UPPER(ltrim(rtrim(:new.PREFIX));
COMM_TGBIU_APEX(:new.create_date,:new.create_user);
END;
/
CREATE OR REPLACE TRIGGER TOOLS.COMM_VERSIONS_TGBU
**BEFORE UPDATE**
ON TOOLS.COMM_VERSIONS
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
:new.NAME := UPPER(ltrim(rtrim(:new.name)));
:new.PREFIX := UPPER(ltrim(rtrim(:new.PREFIX));
COMM_TGBIU_APEX(:new.edit_date,:new.edit_user);
END;
/