File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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


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
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
 
Similar Threads
how to run export utility from java code
JDBC
deleting records in smaller chunks and issuing commit?
how to delete huge amount of records
oracle stored proc for tree