select * from t_test

no items to display

insert into t_test values (1,2)

1 row inserted

rollback

select * from t_test

APEX and SQL Dev Web are *stateless*, ie, between calls there is no knowledge (state) of the previous call, thus an open transaction cannot be left open...In APEX's case, everything that is needed for the next call (values of items etc) will be stored in the database and then retrieved in the next call. And each call could be a different session, ie

- you send a request to us
- we allocate a session to do your work
- we do the work, return results to you if needed
- we release the session

The next call you do, will go through the same process, and thus may obtain a totally different session on the database.

Thus we *must* commit the moment we are going to return control to you.

If you have a series of DML's you would like to run "as one", throw into a PLSQL block which means all of it will complete or none of it will complete.