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

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  

---

What is the function of Redo Log ?

1 Answers  

---

Why oracle is used?

0 Answers  

---

4. Using a set operator, display the creditor number of all creditors who have ever been paid.

2 Answers   Wipro,

---

Why do we need oracle client?

0 Answers  

---

---

What is TNS File

7 Answers   Thermotech,

---

write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"

7 Answers   British Telecom BT,

---

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

0 Answers  

---

write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.

11 Answers   Wipro,

---

What happens if recursive calls get out of control?

0 Answers  

---

how to truncate date and get only time part 9:20:00

5 Answers  

---

Explain table?

0 Answers  

---