What type of statement needs to be committed? ? ?

xiongmao

What type of statement needs to be committed? ? ?

xiongmao

I am new and searched online. But just didn't find the answer.

riki_w

DML statement requires COMMIT

whbilly

If you do not commit, you will still see the old data in other sessions. After committing, you will see the new data.

whbilly

For example:

SQL> conn dbmgr @ stg_bj
Connected to Oracle8i Enterprise Edition Release 8.1.7.4.0
Connected as dbmgr

SQL> create table test000 (userpay number);

Table created

SQL> insert into test000 values ​​(5000);

1 row inserted

SQL> create public synonym test000 for dbmgr.test000;

Synonym created

SQL> grant select on test000 to system;

Grant succeeded

SQL> commit;

Commit complete

SQL> update test000 set userpay = 8000;

1 row updated

SQL> commit;

Commit complete

Before commit, the system user:
SQL> select * from test000;

   USERPAY
----------
      5000

After commit, the system user:
SQL> select * from test000;

   USERPAY
----------
      8000