Re: SQL Plus tells me it has deleted the row, but it hasn't?

In article <9u0tlp$jmf$1_at_new-news.cc.brandeis.edu>, "Vincent says...
>
>
>> try typing "commit" after your delete -- you must commit or transaction
>will
>> be rolled back once you leave your session.
>
>Not true -- if the session is terminated normally Oracle does an implicit
>COMMIT.
>
>

Not totally true (being picky on the semantics here) -- it depends on the environment, it's up to the environment...

sqlplus -- commits on exit.
pro*c -- rolls back on exit..

for example

in this case, yes -- SQLPlus commits on exit -- but don't count on "oracle" in general to commit upon exit...

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp