Answer Posted / pardeep

Using Call keyword we can call procedure inside trigger.
e.g.
CREATE OR REPLACE TRIGGER foo
BEFORE DELETE OR INSERT OR UPDATE ON <<table_name>>
FOR EACH ROW
BEGIN
CALL PROCEDURE_NAME();
END;
/

What privilege is needed for a user to create indexes in oracle?

1078

---

What is the difference between hot backup and cold backup in oracle?

1074

---

How do I know if oracle client is installed on windows?

1090

---

what is the dual table in oracle?

1036

---

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5671

---

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2336

---

what is a Nested Loop join?

2169

---

What is a procedure in oracle?

1276

---

What are the components of logical database structure in oracle database?

1130

---

What is the exact use of Collections?

2190

---

What is analyze command used for?

1122

---

How to set a transaction to be read only in oracle?

1137

---

Explain about functional dependency and its relation with table design?

1058

---

Explain the use of analyse option in exp command.

1186

---

What is a connect identifier?

1083

---