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 are the differences between char and varchar2 in oracle?

0 Answers  

---

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

0 Answers   Wipro,

---

What are synonyms used for ?

3 Answers  

---

Who i will insert 1 lacks record in a Database table

4 Answers   TCS,

---

What is an oracle wallet?

0 Answers  

---

How can one skip any number of rows while loading the DB tables with SQL Loader? Similarly how can one skip any column?

1 Answers   IBM,

---

How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.

2 Answers   AppLabs,

---

How to pass parameters to procedures?

0 Answers  

---

What is the purpose of a cluster?

1 Answers  

---

Can a formula column be obtained through a select statement ?

0 Answers   Oracle,

---

How can we find the size of a database?

2 Answers  

---

What are dml statements in oracle?

0 Answers  

---