Answer Posted / sudhir

by default Trigger doesnt allow a commit;

however we can create a stored procedure which will only do
commit.

create or replace procedure to_commit_trigger
begin
commit();

end to_commit_trigger


now execute this stored procedure to_commit_trigger inside a
trigger to perform a commit. However it will cause serious
performance issues.

How to define a variable of a specific record type?

1061

---

How to invoke the data pump export utility?

1175

---

Explain enable novalidate constraint.

1071

---

How to create a testing table in oracle?

984

---

How to create a new oracle data file?

1025

---

List the various oracle database objects?

1048

---

How to drop an index?

950

---

Does facebook use oracle?

1027

---

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

2012

---

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2089

---

How to use fetch statement in a loop?

1014

---

How to work with data objects interactively?

970

---

How to connect asp pages to oracle servers?

1065

---

What are the various types of snapshots ?

1023

---

How do I know if oracle is installed on windows?

919

---