• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

commit command

 
Romeo Ranjan
Ranch Hand
Posts: 95
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Tom Reilly
Rancher
Posts: 618
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic