Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: if I call a plsql is there a commit?
On Sat, 11 Mar 2006 02:39:59 +0000, ianal Vista wrote:
> "Delio Nasso" <daleanton_at_libero.it> wrote in > news:cbad35a0f0cb6cd1f261fc36846892b0.35030_at_mygate.mailgate.org: > >>> Yes. >>> >>> What problem are you trying to solve? >>> >>> It depends.
> > If/when you see "COMMIT", then there is a commit. > If you don't see those 6 letters, then there is no commit.
Unless ....
if you create, drop or alter in Oracle, there is a commit just before the command is invoked.
if you use SQLPLus, by default there is a commit just before you leave the environment.
-- Hans Forbrich Canada-wide Oracle training and consulting mailto: Fuzzy.GreyBeard_at_gmail.com *** Top posting [replies] guarantees I won't respond. ***Received on Fri Mar 10 2006 - 20:53:25 CST