aspose file tools*
The moose likes Oracle/OAS and the fly likes Do we need to add Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Do we need to add "commit" in DDL ?" Watch "Do we need to add "commit" in DDL ?" New topic
Author

Do we need to add "commit" in DDL ?

Raj Ohadi
Ranch Hand

Joined: Jun 30, 2006
Posts: 316
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

Joined: May 26, 2003
Posts: 30764
    
156

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.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Raj Ohadi
Ranch Hand

Joined: Jun 30, 2006
Posts: 316
appreciate it, Jeanne
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Do we need to add "commit" in DDL ?