wood burning stoves*
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 Murach's Java Servlets and JSP this week in the Servlets 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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30057
    
149

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
 
Consider Paul's rocket mass heater.
 
subject: Do we need to add "commit" in DDL ?
 
Similar Threads
Autocommit for SqlUpdate Spring object
Additional methods which might be called when invoking ejbRemove
Unique constraint and index ?
To call a javascript function using shell script
why my rollback doesn't work?