Transaction Isolation

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 is OFF, unless you force "COMMITT" 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

SQL developer did not have information about the data insertions, elese where