This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes commit command Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "commit command" Watch "commit command" New topic

commit command

Romeo Ranjan
Ranch Hand

Joined: Feb 23, 2009
Posts: 92

I have a question regarding the oracle sql commit command. After executing a set of 20 truncate command.


I finally gave the command COMMIT. Will the commit command will work of all the truncate command or only for the last truncate command, .


SCJP 6.0
Tom Reilly

Joined: Jun 01, 2010
Posts: 618
I'm pretty sure once you issue a truncate, your data is gone. It doesn't wait for a commit. From this web page,
DROP and TRUNCATE are DDL commands, whereas DELETE is a DML command. Therefore DELETE operations can be rolled back (undone), while DROP and TRUNCATE operations cannot be rolled back.
Therefore commit is useless here.
jQuery in Action, 2nd edition
subject: commit command
Similar Threads
how to run export utility from java code
deleting records in smaller chunks and issuing commit?
how to delete huge amount of records
oracle stored proc for tree