Answer / 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 is difference between sql plus and sql*plus? (not sql and sql plus).

0 Answers  

---

What is Oracle table?

1 Answers  

---

What is a Shared SQL pool ?

2 Answers  

---

How to select the name of employee who is getting maximum sal with out using subquery

15 Answers  

---

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

0 Answers  

---

There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep

4 Answers   Microsoft,

---

What is the difference between an Oracle Schema and an Oracle Instance?

3 Answers   IBM,

---

What is a Redo Log ?

3 Answers  

---

Explain the use of grant option in imp command.

0 Answers  

---

How to delete a column in an existing table?

0 Answers  

---

without using count(*) and rownum how can we count total record in a table

5 Answers   AC, HP,

---

How can Oracle users be audited?

0 Answers   MCN Solutions,

---