Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Do we need to add "commit" in DDL ?

 
Raj Ohadi
Ranch Hand
Posts: 316
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In a DDL script that includes table, trigger, sequence, index creations. Do we need to add "commit" syntax at the end or after each "create" block ?
will it be any problem if we don't include the "commit" syntax in the DDL script ?
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34422
347
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Raj,
Either location is fine. You do need a commit somewhere for the changes to take effect. This is true for most tools. A few will auto-commit for you.
 
Raj Ohadi
Ranch Hand
Posts: 316
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
appreciate it, Jeanne
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic