Oracle PL / SQL –重命名触发器

本文向您展示如何使用ALTER TRIGGER重命名触发器。

-- rename a trigger
ALTER TRIGGER original_name RENAME TO new_name;

1.表+触发器

electricity_bill

create table electricity_bill
(
  bill_id number(5) primary key,
  amount number(5)
);

-- Table ELECTRICITY_BILL created.

trg_rename_example

CREATE OR REPLACE TRIGGER trg_rename_example
BEFORE
     UPDATE OR DELETE OR INSERT
ON electricity_bill
  FOR EACH ROW 

BEGIN

  dbms_output.put_line('trg_rename_example Trigger called.');
  
END;

-- Trigger TRG_RENAME_EXAMPLE compiled