Re: Oracle Right or Wrong

Karsten Farell <kfarrell_at_medimpact.com> wrote in news:qoIo9.1651$pC7.197395770_at_newssvr13.news.prodigy.com:

> However, I have to say, I was burned more than once when using
> Sybase's iSQL (funny ... now Oracle has an iSQL, I think ... but
> they always were playing "catch-up" with innovative features the
> "other" databases thought of first). I can't tell you how many
> times I wanted a simple ROLLBACK statement (I know it can be set
> as a db parameter, but our DBAs didn't want to ... they had their
> reasons, I suppose). Having no ROLLBACK made me look very
> carefully at that WHERE clause before sending my DELETE off to
> Sybase.

Missed this:

Sybase T-SQL supports what you want but it's a bit different though:

       begin tran
       <do my thing>
       commit tran  -or- rollback tran

HTH! :)

-- 
Pablo Sanchez, High-Performance Database Engineering
http://www.hpdbe.com