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
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
It's not a secret anymore!