| Author |
Do we need to add "commit" in DDL ?
|
Raj Ohadi
Ranch Hand
Joined: Jun 30, 2006
Posts: 314
|
|
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: 26173
|
|
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: 314
|
|
|
appreciate it, Jeanne
|
|
 |
|
|
subject: Do we need to add "commit" in DDL ?
|
|
|
0
