Answer / chandrakant agrawal

To recompile Trigger:
ALTER TRIGGER <trigger_name> COMPILE;
The trigger can be enabled and disabled manually by using:

Alter Table <table_name> disable(enable) all trigger;

Answer / mk

Usually the trigger code is in a file e.g. trigger_name.sql

To create/replace the trigger object, at the SQL Plus prompt
type

@<folder>/trigger_name.sql

what is 'trigger' in sql? : Sql dba

0 Answers  

---

What is a temp table?

0 Answers  

---

Is pl sql and postgresql same?

0 Answers  

---

What is the purpose of a sql?

0 Answers  

---

What does select count (*) mean in sql?

0 Answers  

---

---

using subquery how can i calculate working days in a month?

3 Answers   Spice Telecom,

---

What are the Diff B/W Cursor and REF Cursor

3 Answers   CTS,

---

What are all the different normalization?

0 Answers  

---

Does sql require a server?

0 Answers  

---

Is pl sql a programming language?

0 Answers  

---

How to run sql statements with oracle sql developer?

0 Answers  

---

what is the difference between the query and corelated query

8 Answers   HSBC, IBM, TCS, Xenosoft,

---