请问什么类型的语句需要提交(commit)???
------解决方案--------------------
DML语句需要COMMIT
------解决方案--------------------
如果不commit,别的session看到的还是旧数据,commit之后,看到新数据
------解决方案--------------------
举例如下:
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
commit之前,system用户:
SQL> select * from test000;
USERPAY
----------
5000
commit之后,system用户:
SQL> select * from test000;
USERPAY
----------
8000