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.
[b]Question asked by visitor Jalpa Patel[/b]
Printable View
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.
[b]Question asked by visitor Jalpa Patel[/b]
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.