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;
/

i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee table

3 Answers  

---

After update how do u know how many records got updated

4 Answers   TCS,

---

What is private procedure oracle?

0 Answers  

---

What is backup in Oracle?

0 Answers   MCN Solutions,

---

SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?

1 Answers   ESS,

---

What is the data pump export utility?

0 Answers  

---

1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?

1 Answers   IBM,

---

Which of the following is not a database object TABLESPACE TABLE INDEX NONE

1 Answers  

---

Is it possible to split the print reviewer into more than one region ?

0 Answers   Oracle,

---

How can we force the database to use the user specified rollback segment?

0 Answers  

---

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

0 Answers  

---

How to convert a date to char in oracle? Give one example.

0 Answers  

---