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 primary key sql?

0 Answers  

---

Can we use delete in merge statement?

0 Answers  

---

What is sql prepared statement?

0 Answers  

---

What is query syntax?

0 Answers  

---

What are expressions?

0 Answers  

---

What is restrict in sql?

0 Answers  

---

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

0 Answers  

---

My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?

2 Answers   CG,

---

What is data control language (dcl)?

0 Answers  

---

How can I get the number of records affected by a stored procedure?

0 Answers  

---

Differentiate pl/sql and sql?

0 Answers  

---

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

0 Answers   CTS,

---