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

When would you denormalize?

8 Answers   MBT, Microsoft, MMU,

---

How to use boolean type in select statement?

0 Answers  

---

what is the command for user data type?

2 Answers  

---

what is rollback? : Sql dba

0 Answers  

---

select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

2 Answers  

---

How can we link a sql database to an existing android app?

0 Answers  

---

What are the differences between in and exists clause?

0 Answers  

---

What is sql scripting?

0 Answers  

---

What is execute immediate?

0 Answers  

---

What is difference between TRUNCATE & DELETE?

16 Answers   Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS,

---

Is subquery faster than join?

0 Answers  

---

Types of joins ?

11 Answers   Polaris, TCS,

---