ALTER TRIGGER name ON table RENAME TO new_name; This command is used to? *
Answers
Answered by
0
Answer:
Not sure what u are saying
Answered by
0
Explanation:
Specify RENAME TO new_name to rename the trigger. Oracle Database renames the trigger and leaves it in the same state it was in before being renamed.
When you rename a trigger, the database rebuilds the remembered source of the trigger in the USER_SOURCE, ALL_SOURCE, and DBA_SOURCE data dictionary views. As a result, comments and formatting may change in the TEXT column of those views even though the trigger source did not change.
Similar questions