Re: Oracle cursor help

From: steves06@xxxxxxxxxxx (Steve Sapovits)
Date: Sat, 25 Jun 2005 23:22:45 -0400


Feeling all confident, I fired up a DELETE/WHERE from SQL*Plus directly,
only to get a weekend call at my nephew's graduation party.  Seems I had
used a ton of rollback and created some very angry DBA's.  I know the query
is okay (very simple WHERE clause) because I was able to select rows using
it in a reasonable amount of time.  Does the rollback issue disappear if
you set auto-commit on?  I would think so but a web search made me not so
sure.  Seems silly that you can't delete rows without an act of Congress.

--
Steve Sapovits  steves06@xxxxxxxxxxx
.

Follow-Ups:
- Re: Oracle cursor help
  - From: Jeff

References:
- RE: Oracle cursor help
  - From: Michael \ Vergara
- Re: Oracle cursor help
  - From: Martin Hall
- Re: Oracle cursor help
  - From: Jeff

Prev by Date: Re: Oracle schema comparison
Next by Date: Re: Oracle cursor help
Previous by thread: Re: Oracle cursor help - retry
Next by thread: Re: Oracle cursor help
Index(es):
- Date
- Thread