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 with example?

0 Answers  

---

What is the maximum number of columns in sql table?

0 Answers  

---

Why is there a need for sqlcode and sqlerrm variables?

0 Answers  

---

what is unique key constraint? : Sql dba

0 Answers  

---

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.

11 Answers   Ebix, Hewitt,

---

What is an ndf file?

0 Answers  

---

what are the advantages of using stored procedures? : Sql dba

0 Answers  

---

What is left join example?

0 Answers  

---

What is meant by Join? What are the different types of Joins available? Explain.

5 Answers   Cap Gemini,

---

What is the use of primary key?

0 Answers  

---

What is the reports view in oracle sql developer?

0 Answers  

---

What are the methods of filing?

0 Answers  

---