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

how to rename an existing column in a table? : Sql dba

0 Answers  

---

What are string functions in sql?

0 Answers  

---

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

0 Answers  

---

What is java sql package?

0 Answers  

---

What are the commands used in sql?

0 Answers  

---

---

what is 'mysqlcheck'? : Sql dba

0 Answers  

---

How do you rename a table in sql?

0 Answers  

---

What is the difference between row level and statement level trigger?

0 Answers  

---

How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)

3 Answers   TCS,

---

Why is there a need for sqlcode and sqlerrm variables?

0 Answers  

---

How many levels can subqueries be nested in a FROM clause?

7 Answers  

---

What is Overloading of procedures ?

2 Answers  

---