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 the use of double ampersand (&&) in sql queries?

0 Answers  

---

how to calculate expressions with sql statements? : Sql dba

0 Answers  

---

What is clustered and non-clustered indexes?

4 Answers   Microsoft,

---

Are dml statements autocommit?

0 Answers  

---

What is file based approach?

0 Answers  

---

---

How does one use sql*loader to load images, sound clips and documents? : aql loader

0 Answers  

---

what is row? : Sql dba

0 Answers  

---

What does cursor do in sql?

0 Answers  

---

What is the difference between count 1 and count (*) in a sql query?

0 Answers  

---

What is sqlca in db2?

0 Answers  

---

What does truncate mean in sql?

0 Answers  

---

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

0 Answers   Microsoft,

---