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

What is the difference between postgresql and oracle?

498

---

What happens to the current transaction if the session is killed?

519

---

Explain an index?

646

---

How to rename an index?

573

---

What is a subquery in oracle?

566

---

---

How to assign query results to variables?

578

---

Explain the use of online redo log files in oracle.

565

---

What are set operators?

638

---

Can multiple columns be used in group by in oracle?

531

---

What privilege is needed for a user to create views in oracle?

574

---

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

1594

---

Differentiate between function and procedure in oracle.

547

---

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

1772

---

How to connect to the server with user account: sys?

547

---

how the indexes are stored in the Oracle Database?

1728

---