-
commit statement
hello all..
Just a basic question ....
I have user USER_A connected to ORacle Database from 2 different workstations.
When USER_A from Workstation WK1 deleted some records from table_1, and not issued Commit, can user_a from WK2 see the new results or should he reconnect to see the results from WK2 ?..
When exactly does USER_A at WK2 see the results done by USER_A at WK1 ?...
Thanks
Ron
-
-
It is session specific. there is no relation with User .
Last edited by mdash; 01-17-2003 at 06:56 PM.
-
Originally posted by mdash
It is session specific. there is no relation with User .
Oh, really?
session 1 as scott:
SQL> select count(*) from emp;
COUNT(*)
----------
13
session 2 as scott:
SQL> select count(*) from emp;
COUNT(*)
----------
13
session 1:
SQL> delete from emp;
13 rows deleted.
SQL> select count(*) from emp;
COUNT(*)
----------
0
session 2:
SQL> select count(*) from emp;
COUNT(*)
----------
13
session 1: do the commit
SQL> commit;
Commit complete.
session 2: is the data still there?
SQL> select count(*) from emp;
COUNT(*)
----------
0
NO
-
Re: commit statement
Originally posted by vr76413
I have user USER_A connected to ORacle Database from 2 different workstations.
Save yourself the walking. It doesn't matter that the same user is on different workstations. What does matter is the same user has two different sessions, which can be initiated from the same workstation.
-
stecal,
I told samething whatever U mentioned .I have not described it.
My purpose was to make clear that only after commiting in 1st session 2nd session can see it . It doesn't matter whehter U are using same user or different user in both the session.
-
I see. The example was with the same user, but that doesn't matter either. I misunderstood what you meant by user.
-
No change is visible to a second user until it has been commited. Remember your rollback segmentgs?
Life is what is happening today while you were planning tomorrow.
-
I see. The example was with the same user, but that doesn't matter either. I misunderstood what you meant by user.
Stecal, think before you jump to a conclusion. Good for your future.
Agasimani
OCP(10g/9i/8i/8)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|