File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 Android Security Essentials Live Lessons this week in the Android 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: 95

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.
I agree. Here's the link:
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