aspose file tools*
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
Author

commit command

Romeo Ranjan
Ranch Hand

Joined: Feb 23, 2009
Posts: 95
Hi ALL,

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

example:


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

Thanks.


SCJP 6.0
Tom Reilly
Rancher

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: http://aspose.com/file-tools
 
subject: commit command