Answer Posted / santosh kumar

Yes ,You can Commit inside the trigger.

But for this you have to make this trigger transaction to be a Independent transaction from its parent transaction, You can do this by using Pragma. Pragma AUTONOMOUS_TRANSACTION allow you to build the Indepadent(child) Transaction,started by another. Shold be declare in DECLARE section of any subprogram.

Used to make Modular and Resuable Blocks. if you need the example then ask to me.

CREATE OR REPLACE TRIGGER TRIG_ARG
AFTER INSERT ON TAB1
DECLARE
PRAGMA AUTONOMOUNS_TRNASACTION
BEGIN
INSERT INTO LOG VALUES(SYSDATE,'INSERT ON TAB1');
COMMIT;
END;
/

OR

CREATE OR REPLACE TRIGGER t_trigger
AFTER INSERT ON t1 FOR EACH ROW

DECLARE
PRAGMA AUTONOMOUS_TRANSACTION;
i PLS_INTEGER;
BEGIN
SELECT COUNT(*)
INTO i
FROM t1;

INSERT INTO t2
VALUES
(i);
COMMIT;
END;
/

How many aggregate functions are available there in sql?

977

---

What is left join in sql?

1043

---

how to convert dates to character strings? : Sql dba

1157

---

Is join same as left join?

1027

---

define sql update statement ? : Sql dba

1109

---

Are stored procedures compiled?

910

---

How do you sort in sql?

1001

---

What are the packages in pl sql?

1005

---

How do you use a while loop in pl sql?

999

---

What is dense_rank?

931

---

How do I filter in sql profiler?

990

---

what are different types of collation sensitivity? : Sql dba

1060

---

What is an alias command?

1052

---

Is and as keyword in pl sql?

951

---

What are expressions?

1000

---