数据库提交问题？

Question

我想你只能在sqlplus中设置
要每次都这样，可以在 ...\sqlplus\glogin.sql 中加入 set autocommit on
SQL> set autocommit on
SQL> select  * from aa;         A          B          C
---------- ---------- ----------
         7          7          7
         1          1          3
         2          2          5
         6         -1         -1
         7          7          7
         7          7          7
         7          7          7
         7          7          7
        33         44
         7          7          7
         7          7          7
         7          7          7
         7          7          7
         7          7          7已选择14行。已用时间:  00: 00: 00.03
SQL> insert into aa values(8,8,8);已创建 1 行。提交完成。
已用时间:  00: 00: 00.25
SQL> roll;
重算已完成。
SQL> select  * from aa;         A          B          C
---------- ---------- ----------
         7          7          7
         1          1          3
         2          2          5
         6         -1         -1
         7          7          7
         7          7          7
         7          7          7
         7          7          7
        33         44
         7          7          7
         7          7          7
         7          7          7
         7          7          7
         7          7          7
         8          8          8已选择15行。已用时间:  00: 00: 00.63
SQL>

Answer 1

你可以把 set autocommit on  加入  ....\sqlplus\glogin.sql
这样就成默认的设置了
SQL> set autocommit on
SQL> select  * from aa;         A          B          C
---------- ---------- ----------
         7          7          7
         1          1          3
         2          2          5
         6         -1         -1
         7          7          7
         7          7          7
         7          7          7
         7          7          7
        33         44
         7          7          7
         7          7          7
         7          7          7
         7          7          7
         7          7          7已选择14行。已用时间:  00: 00: 00.03
SQL> insert into aa values(8,8,8);已创建 1 行。提交完成。
已用时间:  00: 00: 00.25
SQL> roll;
重算已完成。
SQL> select  * from aa;         A          B          C
---------- ---------- ----------
         7          7          7
         1          1          3
         2          2          5
         6         -1         -1
         7          7          7
         7          7          7
         7          7          7
         7          7          7
        33         44
         7          7          7
         7          7          7
         7          7          7
         7          7          7
         7          7          7
         8          8          8已选择15行。已用时间:  00: 00: 00.63
SQL> set autocommit off

Answer 2

biti_rainy(biti_rainy)兄大概看错了，贴主要求的是手动提交，其实sql plus本身就是手动提交的