Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!csd4.milw.wisc.edu!lll-winken!indri!uflorida!haven!umd5!jay
From: jay@umd5.umd.edu (Jay Elvove)
Newsgroups: comp.databases
Subject: Re: SQL Standardization
Keywords: module language, implicit commit
Message-ID: <4966@umd5.umd.edu>
Date: 5 Jun 89 12:05:45 GMT
References: <1120@ethz.UUCP> <16856@sequent.UUCP>
Reply-To: jay@umd5.umd.edu (Jay Elvove)
Organization: University of Maryland, College Park
Lines: 22

In article <16856@sequent.UUCP> john@sequent.UUCP (John Vander Borght) writes:
>
>Oracle states in the SQL*Plus Reference Guide Version 2.0 on page 2-33 (Commit)
>
>"The following commands also commit changes to the database:
>ALTER, AUDIT, COMMENT, CONNECT, CREATE, DISCONNECT, DROP, EXIT, GRANT, NOAUDIT,
>QUIT, REVOKE, and RENAME."
>
In the newest PC release of ORACLE (v51B), the Reference Guide has been
superseded by a much thinner reference manual (2.1) that lists only four of
the above commands under the description of COMMIT (page 2-21):  CONNECT,
DISCONNECT, EXIT, and QUIT.  A vague pointer to "Transactions" in the Database
Administrator's Guide has been added, however.  After a few failed attempts
to find further information under that subject heading, I did find a subset of
the above (specifically, CREATE and DROP) listed on page 133 of the DBA Guide.
Any ideas as to why the information might have changed in going from the SQL
Reference Guide to the newer Manual?
-- 

Jay Elvove       jay@umd5.umd.edu
c/o Academic Software
Comp. Sci. Center, Univ. of Md., College Park