Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Access "magic" -- invisible Oracle rows?
I stand corrected; only DDL statements, not DML ones, cause an implicit commit;
Sometimes, when replying to postings, thinking becomes optional :-(
John Greco
Andy Hardy <Andy_Hardy_at_camk.demon.co.uk> wrote:
>In article <34980da8.72658106_at_news.primenet.com>, TurkBear
><jvgreco_at_pop.primenet.com> writes
>>As stated, the 'commit' is the key.... but it need not be explicitly
>>entered - the next 'select ..... from sametable' will do a commit
>>before the select....( so will exiting SqlPlus )
>>
>I don't think so?
>
>Surely a select statement does not imply that previous work be
>committed?
>
>Andy
>--
>Andy Hardy
>Senior IT Systems Engineer
>Cegelec AEG
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>Opinions are mine and do not necessarily reflect those of Cegelec AEG
Received on Thu Dec 18 1997 - 00:00:00 CST