如果DDL语句崩溃,会发生什么?(Oracle数据库)

DDL即使失败也会隐式提交您的事务,下面是Ask tom的一个示例:

create table t (
  x int
);

insert into t values (1);

alter table t add (x varchar2(10)); -- duplicate column

SQL Error: ORA-01430: column being added already exists in table

rollback;

select * from t;

X  
1  

https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:9532421900346923086