my dog learned polymorphism*
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: 30370
    
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Do we need to add "commit" in DDL ?