update (temporary)
Posted: Fri Jun 13, 2008 6:54 am
Hi,
I have a job which updates an oracle database. I would like to test the working of this job, but at the same time not update the database as other ppl are depended on it.
I know that I shouldn't commit after execution of the sql.
a) If I someway do not commit, then can others use the data without any additional step to revert back to original data.
b) how do we not commit.
I have a job which updates an oracle database. I would like to test the working of this job, but at the same time not update the database as other ppl are depended on it.
I know that I shouldn't commit after execution of the sql.
a) If I someway do not commit, then can others use the data without any additional step to revert back to original data.
b) how do we not commit.