wood burning stoves 2.0*
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
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30116
    
150

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 ?
 
Similar Threads
why my rollback doesn't work?
To call a javascript function using shell script
Autocommit for SqlUpdate Spring object
Additional methods which might be called when invoking ejbRemove
Unique constraint and index ?