oracle 执行sql出错了就回滚
屎克螂 2013-11-02 12:18:05 比如执行如下语句:
grant create any directory to system;
/
create directory tmp as 'C:\Users\guozhixing\Desktop\案例\web\圈人\img';
/
create table FACELOOK_ACTIVITY
(
FA_ID NUMBER(10) not null,
FU_USER_ID VARCHAR2(20) not null,
FA_TIME DATE not null,
FA_TYPE NUMBER(6) not null,
FP_PHOTO_ID NUMBER(10) not null,
FC_ID NUMBER(10),
FM_ID NUMBER(10)
)
。。。。。。等等
当中出错了,就回滚全部