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.