After Oracle update data, query time, data is automatically restored-CodePudding

Oracle update data, query time, data is automatically restored, I see the video, the teacher after updating the data, there is no commit, he is still there, after the search data if commit, just can't rollback to savepoint operation, I want to the savepoint operation, completely unable to realize,

CodePudding user response:

You of the experimental process, detailed said, contains several sessions, each session statement execution order, all say once

CodePudding user response:

reference 1st floor selling fruit net reply:

you of the experimental process, detailed said, contains several sessions, each session statement execution order, said the

The delete from my_employees;
Select * from my_employees;
Display: data all gone
Select * from my_employees;
Display: all before the delete data

CodePudding user response:

call me little job references 2 floor response:

Quote: refer to 1st floor selling fruit net reply:

You of the experimental process, detailed said, contains several sessions, each session statement execution order, said the

The delete from my_employees;
Select * from my_employees;
Display: data all gone
Select * from my_employees;
Show that the data was all before the delete

Another example:
The update my_employees
The set salary=1000
Where id=1;
Select * from my_employees;
Display: id of 1 salalry 1000
Select * from my_employees;
Display: id of 1 salary is 850 (before change)

CodePudding user response:

1.
The delete from my_employees;
Select * from my_employees;
Display: data all gone

2.
Select * from my_employees;
Show that the data was all before the delete

Is this two sessions? Or, are you opened two Windows?

CodePudding user response:

references 4 floor selling fruit net reply:

1.
The delete from my_employees;
Select * from my_employees;
Display: data all gone

2.
Select * from my_employees;
Show that the data was all before the delete

Is this two sessions? Or, are you opened two Windows?

CodePudding user response:

The delete from my_employees;
Commit;

Select t. *, rowid from my_employees t;

Select t. *, rowid from my_employees t;

CodePudding user response:

refer to 6th floor selling fruit net reply:

delete from my_employees;
Commit;

Select t. *, rowid from my_employees t;

Select t. *, rowid from my_employees t;

but can't commit a rollback

CodePudding user response:

refer to 6th floor selling fruit net reply:

delete from my_employees;
Commit;

Select t. *, rowid from my_employees t;

Select t. *, rowid from my_employees t;

I look at the others, are all the delete, no matter how to select, there are no data reduction, also can undertake a rollback operation, if the commit, will not be able to rollback

CodePudding user response:

Where do you have a rollback operation process of experiment?

CodePudding user response:

references 9 floor selling fruit net reply:

your experimental process, where there is a rollback operation?

CodePudding user response:

The second time the select is in the same window (session), or another window (session) running?

CodePudding user response:

references to the tenth floor call me little gao reply:

Quote: selling fruits, 9/f, reference net reply:

Where do you have a rollback operation process of experiment?

, which was originally conceived to savepoint, then a rollback operation, but because no rollback operation data automatic reduction is necessary, but if I can delete several times, can't do the realization of the rollback

CodePudding user response:

reference 11 floor selling fruit net reply:

select a second time is in the same window (session), or another window (session) running?

the same

CodePudding user response:

The delete from my_employees;

Select t. *, rowid from my_employees t;

Select t. *, rowid from my_employees t;

Look at the results

CodePudding user response:

reference 14 floor selling fruit net reply:

delete from my_employees;

Select t. *, rowid from my_employees t;

Select t. *, rowid from my_employees t;

Look at the results

CodePudding user response:

reference 14 floor selling fruit net reply:

delete from my_employees;

Select t. *, rowid from my_employees t;

Select t. *, rowid from my_employees t;

See

I want effect, delete the data in the table, regardless of the query several times is empty, only after a rollback, only can be restored in the table, not now, query the second direct data reduction

CodePudding user response:

The trigger on the table?

CodePudding user response:

The

cited the 17th floor minsic78 reply:

triggers on the table? nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull