I just want to commit my second Insert statement

[Geek_Guest]

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

[debasisdas]

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.