Re: Commit and ANSI SQL

In article <C1K62G.4H6_at_jbecpor.demon.co.uk>, smj_at_jbecpor.demon.co.uk (Martin Jarvis) writes:
|> I've just had a discussion with some colleagues about the use of Commit in
|> Oracle. In particular that a commit will save _all_ outstanding changes. My

Commit commits the current transaction. i.e. everything between _your_ last commit/rollback and _your_ commit statement. It has no effect on anybody else's transactions. How could it??

|> boss seems to think that other databases allow concurrent transactions, thereby
|> allowing individual changes to be saved separately.
|>
|> What does the ANSI standard for SQL say about this ?
|>
|> ________________________________________________________________________________
|> Martin Jarvis | Internet - smj_at_jbecpor.demon.co.uk
|> John Brown E & C Ltd | X.400 - Martin Jarvis /JBEC-Portsmouth, IT
|> Portsmouth, England |
 

-- 
                               John Peach
                           Chevron (UK) Ltd.
   Ninian House, Crawpeel Road, Altens, Aberdeen, AB1 4LG, Scotland.
   Internet: epeas_at_aberdeen.chevron.com       Phone: +44 224 242637