A workaround to this is to supply a default value to the not NULL column whose value comes from a BEFORE INSERT TRIGGER, so that the constraint is not violated.
一种解决方法是给从BEFORE INSERT触发器取得值的NOT null列提供默认值,这样就不会违反约束。
In Oracle 10g, if there is a BEFORE INSERT TRIGGER and a NOT NULL constraint on a table, then the BEFORE TRIGGER is executed first, and then the constraint check is performed.
在Oracle10g中,如果表上同时存在BEFORE INSERT触发器和NOT NULL约束,那么先执行BEFORE触发器,然后执行约束检查。
Note: Alternatively you can create a database trigger to capture every INSERT on your table and tell it to validate the data as XML using the XMLVALIDATE function before performing the INSERT.
注意:您也可以选择创建一个数据库触发器来捕捉表上的每个INSERT操作,并告诉它在执行INSERT之前使用XMLVALIDATE函数验证XML数据。
I made no doubt that I could readily displace the bricks at this point, insert the corpse, and wall the wall up as before, so that no eye could detect anything suspicious.
我确信我可以很容易地把这部分的砖挖开,把尸体塞进去,再像以前一样把墙砌好,这样就没有人会发现可疑之处了。
As shown in Listing 5, the revised INSERT statement invokes the XMLValidate function before specifying a parameter marker for the XML data.
如清单4所示,修订后的insert语句在为XML数据指定参数标志符之前调用xmlvalidate函数。
If the suppository is too soft to insert, chill it in the refrigerator for 30 minutes or run cold water over it before removing the foil wrapper.
如药栓过软,可在在除去箔纸前先在冰箱内冷藏30分钟,或用冷水冲。
Being an SQL statement, an INSERT statement must be compiled by DB2 before it's executed.
作为一条sql语句,insert语句在执行之前必须由DB 2进行编译。
In the film, the speech therapist used a similar method by having King George insert an "ah" sound into a sentence before a treacherous word.
电影中,语言矫正师也用类似的办法帮国王,比如他在一个特别难发的词前面加了一个“啊”。
You know that it has at least one sentence, so create your command element and insert all of the text before the first period.
您知道最少要有一个句子,因此将创建command元素,并把第一个句号之前的内容放进去。
Once you separate the string into a sequence, you can also use the new sequence-manipulation functions, such as insert-before , to alter it.
一旦将字符串分解成序列,就可以用新的序列操作函数如insert - before来修改它。
Also, BEFORE triggers can now contain UPDATE, DELETE, INSERT and routines that modify data.
另外,BEFORE触发器现在可以包含UPDATE、DELETE、INSERT和修改数据的例程。
Insert-after is similar to insert-before but adds the element after the selected node. You could insert element model as follows.
insert -after类似于insert - before,但是在选定的节点之后添加元素。
To insert strips of fat or bacon in (meat) before cooking.
在烹调之前嵌入片状脂肪或腌肉片于肉中。
I knew where to insert my dime. I had seen it done before and had fantasized about this moment many times.
我知道该往哪儿插硬币,我曾看人做过并曾多次幻想有一天我也能亲身试一试。
If you delete words from the original quote, insert an ellipsis, three periods with a space before and after each one. .
如果你去掉引文中的一些单词,用省略号(三个前后有空格的小圆点)。
If you would like to make a comment or insert a remark in an ongoing conversation, it is polite to acknowledge what someone has just said before stating your own ideas.
如果你想在正在进行中的谈话发表评论或插话,礼貌的做法是先确定别人说的然后再说你的想法。
If you delete words from the original quote, insert an ellipsis, three periods with a space before and after each one.
如果你去掉引文中的一些单词,用省略号三个前后有空格的小圆点。
If you delete words from the original quote, insert an ellipsis, three periods with a space before and after each one.
如果你去掉引文中的一些单词,用省略号三个前后有空格的小圆点。
应用推荐