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

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.

2325

---

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2439

---

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2405

---

What is the string concatenation operator in oracle?

1103

---

What is a tns file?

948

---

How does oracle handle read consistency?

1054

---

Explain a segment?

1033

---

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2908

---

Can a parameter be passed to a cursor?

1059

---

what is the difference between data migration and production migration.

2282

---

How to create an oracle database manually?

1027

---

What are the predefined tablespaces in a database?

1015

---

How to get the Installed Oracle Version Information ?

1082

---

Explain how are indexes update?

1024

---

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2263

---