Wednesday, December 17, 2008

Execute immediate and commit

Some tips for the execute immediate pl/sql command and when it dows commit.

When you use execute immediate for dml statements then you must explicity commit.

But when you use execute immediate for ddl statements then all previous dnml statements in a transaction are explicity commited.

3 comments:

  1. Hіya, I'm really glad I've found this information.
    Nowadays bloggerѕ publish onlу about
    gossiρs and intегnet anԁ thіs is aсtually irrіtаtіng.

    A goоd blog with exciting сontent, this iѕ what I need.

    Τhank уou for keеping this webѕite, I ωill be vіsiting іt.

    Do you do newsletters? Cant find іt.
    My web site > brotmaschine

    ReplyDelete
  2. Hello to all, it's in fact a good for me to visit this site, it consists of precious Information.
    Also visit my page ; barbapapa malvorlage

    ReplyDelete
  3. Ι got thhis sіte from my fiend whо shаred with me about
    this ωeb pаge аnd at the moment this time I am viѕiting this
    wеbsite аnd гeadіng veгy informative
    aгticlеs at this time.

    ReplyDelete