Thread: I just want to commit my second Insert statement

Suppose I have 3 insert statements. But I just want to commit my second Insert statement. How it is possible in SQL? It was asked to me in Oracle Interview.

Question asked by visitor Jalpa Patel

That is not possible directly uisng SQL.
To achieve that u nee do write a procedure and through that u need to insert tthe second record.
and this transaction must be declared as AUTONOMOUS TRANSACTION.