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

How many categories of data types?

994

---

Explain coalesce function?

1201

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4520

---

Why we use bulk collect in oracle?

1044

---

How do I limit the number of oracle database connections generated by weblogic server?

1070

---

Differentiate between post-database commit and post-form commit?

1037

---

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2368

---

Explain the use of rows option in imp command.

1085

---

What is the relation of a user account and a schema?

1134

---

What happens if you lost a data file?

1034

---

What is integrity and what is constraint??Explain with example

2283

---

How would you change old and new values in an insert, delete and update triggers?

1020

---

Difference between cartesian join and cross join?

1039

---

What is the Tune Query

2291

---

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

1087

---