Skip to content

How Oracle Rename Trigger

  • by

ALTER TRIGGER RENAME TO

To rename a trigger, we can use ALTER TRIGGER RENAME TO statement to rename it. For example:

SQL> show user
USER is "OE"
SQL> select object_type from user_objects where object_name = 'INSERT_ORD_LINE';

OBJECT_TYPE
-----------------------
TRIGGER

SQL> alter trigger insert_ord_line rename to insert_order_line;

Trigger altered.

We have changed the trigger name.

Leave a Reply

Your email address will not be published. Required fields are marked *