Transaction Isolation1.htm
Two processes SQL Plus and SQL Developer
  • note the separation
Let us create a table S1; with sql-developer I clicked on Commit to enroll this table

DROP TABLE S1;
CREATE TABLE S1
(
eid NUMBER(2) NOT NULL,
fname VARCHAR(20),
lname VARCHAR(30),
address VARCHAR(100),
CONSTRAINT pk_S1 PRIMARY KEY (eid)
);

 

Next I would insert few rows:

INSERT INTO S1
VALUES (10, 'Anita','Das', 'Address 1');
INSERT INTO S1
VALUES (11, 'Frank','Delon', 'Address 2');
INSERT INTO S1
VALUES (12, 'Juno','Rastogi', 'Address 3');
INSERT INTO S1
VALUES (13, 'Sunil','Pandey', 'Address 4');
 

Now run a query and don't use COMMIT," ignore ugly column formatting", 

Now format the columns

SQL> column fname format a10
column lname format a15
column address format a15
select * from s1;

Since Auto commit feature of Oracle was turned OFF, locally in this SQL*Plus application Pane, other application / processes would not have any information about the data inserted @ this SQL*Plus.

Now Open another SQL * Plus command terminal /pane and execute "select * from s1", note the report "no rows selected" in the screen shot below.

The application, Oracle SQL developer,  did not have any information, either, about the data insertions in phase happening else where, till the transaction was enforced to commit. ( shown in the next document)