Re: before closing connection does commit query is executed or not
Date: 18 May 2002 05:21:43 -0700
Message-ID: <c89fe0be.0205180421.706cce18_at_posting.google.com>
Whether you are talking about a PL/SQL Block or a DML statement
followed by an exit, there is no implicit commit executed.
If the DBA has set AUTOCOMMIT ON, in that case your statement might
get committed, but this is not dependable and one must always
carefully design their application or use commits for SQL's.
You definitely would benefit from Oracle documentation which you can
download from a Oracle CD.
Cheers
andrija.rubelj_at_konzum.hr (andrija) wrote in message news:<4bcceb3d.0205160354.3148da6b_at_posting.google.com>...
-Sandeep
> sachin_at_amsoft.net (Sachin Chadha) wrote in message news:<9140b7ad.0205142353.6012f462_at_posting.google.com>...
> > before closing a database connection is commit query executed automatically
> > or we have to explicitly commit.
>
> Before closing a database connection, is select sysdate from dual
> executed automatically? No it isn't. Same is with commit.
Received on Sat May 18 2002 - 14:21:43 CEST