How do I compile an ORACLE trigger [closed]

Question

I have an invalid ORACLE trigger.

How can I compile it with SQL*PLUS?

How can I see the status with SQL*PLUS?

Answer 1

You can recompile using ALTER TRIGGER:

ALTER TRIGGER myTrigger COMPILE

If SQLPlus reports Trigger compiled with errors (or something similar), just type SHOW ERRORS for more information.