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 update values in a table in oracle?

1077

---

Why does Oracle not permit the use of PCTUSED with indexes?

2479

---

What is a table in oracle?

1022

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1993

---

What is the exact use of Collections?

2190

---

What is transport network substrate (tns) in oracle?

1091

---

Explain oracle’s server parameter file.

1041

---

How to change system global area (sga) in oracle?

1066

---

What is an anonymous block?

1324

---

What is a proxy class?

1106

---

How to use "out" parameter properly?

1124

---

Explain the use of compress option in exp command.

1070

---

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

2040

---

Explain oracle 12c new features for developers?

1125

---

What is procedure overloading in oracle?

1113

---