Maybe you can't rollback a SELECT statement, but it can be part
of a transaction.
Using Oracle as an example:
Session 1:
create table x ( x number );
insert into x values(1);
commit;
Session 2:
commit;
set transaction read only;
select * from x;
X
------
1
1 rows selected.
Session 1:
delete from x;
commit;
select * from x;
no rows selected.
Session 2:
select * from x;
X
------
1
1 rows selected.
Jared
On Thursday 07 February 2002 14:49, Ronald J Kimball wrote:
> On Thu, Feb 07, 2002 at 04:41:31PM -0500, Ronald J Kimball wrote:
> > Selects, updates, and deletes are part of a transaction; they can be
> > commited and rolled back. Creates and alters are not; they happen
> > immediately and cannot be rolled back.
>
> Selects? Oops. :D I didn't think that explanation through completely.
> Rolling back a select wouldn't even make sense.
>
> I should have said inserts, updates, and deletes.
>
> Ronald
