deferrable initially deferred
来源:互联网 发布:战舰世界德克萨斯数据 编辑:程序博客网 时间:2024/06/08 06:49
DEFERRABLE Clause The DEFERRABLE and NOT DEFERRABLE parameters indicate whether or not, in subsequent transactions, constraint checking can be deferred until the end of the transaction using the SET CONSTRAINT(S) statement. If you omit this clause, then the default is NOT DEFERRABLE.Specify NOT DEFERRABLE to indicate that in subsequent transactions you cannot use the SET CONSTRAINT[S] clause to defer checking of this constraint until the transaction is committed. The checking of a NOT DEFERRABLE constraint can never be deferred to the end of the transaction.If you declare a new constraint NOT DEFERRABLE, then it must be valid at the time the CREATE TABLE or ALTER TABLE statement is committed or the statement will fail.Specify DEFERRABLE to indicate that in subsequent transactions you can use the SET CONSTRAINT[S] clause to defer checking of this constraint until after the transaction is committed. This setting in effect lets you disable the constraint temporarily while making changes to the database that might violate the constraint until all the changes are complete.You cannot alter the deferrability of a constraint. That is, whether you specify either of these parameters, or make the constraint NOT DEFERRABLE implicitly by specifying neither of them, you cannot specify this clause in an ALTER TABLE statement. You must drop the constraint and re-create it.
http://docs.oracle.com/cd/B19306_01/server.102/b14200/clauses002.htm#i1002038
0 0
- deferrable initially deferred
- INITIALLY DEFERRED
- Oracle中Constraint的状态参数initially与deferrable
- alter table 语句中的deferable initially deferred
- enable validate deferrable
- Oracle deferrable、immediate 约束
- linux interrupt, deferrable function
- DEFERRABLE约束切换实验
- 12.3.1 Initially assigned variables
- 12.3.2 Initially unassigned variables
- 创建constraint时的选项:not deferrable和deferrable
- 1.Deferrable 延时校验(优化)
- immediate约束和deferrable约束
- dojo.Deferred
- DEFERRED IMMEDIATE
- Deferred Shading
- Deferred Shading
- Deferred Decal
- 深入剖析ThreadLocal
- 音视频框架ffmpeg源码的简要分析
- 随手一点小记录
- java里面的FutureTask简单使用(配合源码讲解)
- 企业怎样选择DOT认证机构?
- deferrable initially deferred
- Mybatis调用sqlserver2008存储过程
- 友情链接
- 4EC
- 深度学习中的非线性激励函数以及unsupervised pre-training
- IOS中可以一个多个xib文件对应一个类。当然也可以在一个Xib中创建多个view然后也是用一个类控制
- Kafka单机、集群模式安装详解(一)
- MyBatis的几种批量操作
- collection 集合基本结构