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 check myisam tables for errors? : Sql dba

0 Answers  

---

Can you join views in sql?

0 Answers  

---

Are dml statements autocommit?

0 Answers  

---

How to return multiple rows from the stored procedure?

0 Answers  

---

How do you display "13th of November, 17 days left for month end" without hardcoding the date.

3 Answers  

---

How to Declare Fixed Length String Value In PL SQL

0 Answers  

---

What are sql ddl commands?

0 Answers  

---

Which is better stored procedure or query?

0 Answers  

---

What is foreign key in sql with example?

0 Answers  

---

Initially question was asked to mention the types of indexes. Then asked about BITMAP INDEX and B-Tree Index

2 Answers   Polaris,

---

Do view contain data?

6 Answers   Ramco,

---

Why do we need cursor in pl sql?

0 Answers  

---