Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
I just want to commit my second Insert statement
This is a discussion on I just want to commit my second Insert statement within the Oracle forums, part of the Databases category; 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. ...
|
|||||||
| Oracle Oracle 9i & Oracle 10g Knowledge Base Learn and Share Oracle Technology related articles, white papers, tutorials / study materials, example codes, FAQ's, Tips and Tricks. |
 |
| LinkBack | Thread Tools | Display Modes |
07-21-2007
|
|||
|
|||
|
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 
|
| Sponsored Links |
|
07-21-2007
|
|||
|
|||
|
Re: I just want to commit my second Insert statement
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.
|
|
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Is this a correct statement | anoop4real | C and C++ | 13 | 05-22-2008 07:22 AM |
| Why we have to close connection, statement, prepared statement | Geek_Guest | Java | 8 | 02-27-2008 07:09 AM |
| Sequence of commit triggers | Geek_Guest | Oracle | 0 | 07-10-2007 01:49 PM |
| System crashed after giving COMMIT command | Geek_Guest | SQL | 1 | 07-09-2007 04:11 AM |
| two-phase commit.... | psuresh1982 | Oracle Apps | 1 | 02-19-2007 02:18 AM |
All times are GMT -4. The time now is 02:14 PM.
