SQL> create table cust(id number,name varchar2(10)); Table created SQL> alter table cust add constraint cust_id_pk primary key(id) deferrable initially deferred;--延缓约束 Table altered SQL> insert into cust values(1,'raj'); 1 row inserted SQL> insert into cust values(1,'sam'); 1 ...
SQL> create table cust(id number,name varchar2(10)); Table created SQL> alter table cust add constraint cust_id_pk primary key(id) deferrable initially deferred;--延缓约束 Table altered SQL> insert into cust values(1,'raj'); 1 row inserted SQL> insert into cust values(1,'sam'); 1 ...
[ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE action ] [ ON UPDATE action ] } [ DEFERRABLE | NOT DEFERRABLE | INITIALLY DEFERRED | INITIALLY IMMEDIATE ] where index_parameters can be: [ WITH ( {storage_parameter = value} [, ... ] ) ] [ USING INDEX TABLESPACE tablespace...
【测试类型:SQL功能】【测试版本:6.0.0】【ustore】 ustore表使用进行外键约束deferrable initially deferred创建后,存在部分情况commit时无法检查约束 【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a): CentOS Linux release 7.7.1908 (Core) 【测试环境】(单机/1主x备x级联备): 单机 【...
DEFERRABLE | NOT DEFERRABLE:约束触发器的启动时机,仅作用于约束触发器。这两个关键字设置该约束是否可推迟。 INITIALLY IMMEDIATE | INITIALLY DEFERRED:如果约束是可推迟的,则这个子句声明检查约束的缺省时间,仅作用于约束触发器。 FOR EACH ROW | FOR EACH STATEMENT:触发器的触发频率。FOR EACH ROW是指该触发器...
【测试类型:SQL功能】【测试版本:6.0.0】【ustore】 ustore表使用进行外键约束deferrable initially deferred创建后,存在部分情况commit时无法检查约束 【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a): CentOS Linux release 7.7.1908 (Core) ...
3 DEFERRABLE INITIALLY DEFERRED; Table altered. --插入条记录后提交,给出违反了约束并出现回滚 SQL> INSERT INTO tb_cust SELECT 10,'Jay' FROM DUAL; 1 row created. SQL> INSERT INTO tb_cust SELECT 10,'SAM' FROM DUAL; 1 row created.
DEFERRABLE INITIALLY IMMEDIATE约束指定在事务执行期间是否要推迟(DEFERRED)对约束的检查。INITIALLY IMMEDIATE表示在事务开始时立即检查约束。而DEFERRABLE表示可以在事务期间通过显式命令延迟检查约束。换句话说,DEFERRABLE INITIALLY IMMEDIATE约束在事务开始时立即检查,并且不允许推迟对约束的检查。
SET CONSTRAINT aa DEFERRED;//将immediate改为deferred; SET CONSTRAINT aa IMMEDIATE;//将deferred改为immediate; 举例: (1) CREATE TABLE Course( id intREFERENCES Person (id) DEFERRABLE INITIALLY DEFERRED, //延迟约束检查; name varchar(30) );
{ NOT DEFERRABLE | [ DEFERRABLE ] { INITIALLY IMMEDIATE | INITIALLY DEFERRED } } [ FOR [ EACH ] { ROW | STATEMENT } ] [ WHEN ( condition ) ] EXECUTE PROCEDURE function_name ( arguments ); 主要参数说明: CONSTRAINT:可选项,指定此参数将创建约束触发器,即触发器作为约束来使用。除了可以使用SET...