trigger

[dhallib]

I'm to move a trigger from dev to prod. The problem is if I create the trigger, it will automatically fire because new data is coming into prod. How do I go about creating the trigger but in a disable form?

[hinermak]

Build your trigger and then immediatley disable it...
CREATE or REPLACE TRIGGER <trigger>
...
...
...;

ALTER TRIGGER <trigger> DISABLE;

[dhallib]

Thanks for the information.
That's what I ended up doing.