WITH CHECK OPTION的用法
摘要:1. INSERTINSERT INTO(<SELECT CLAUSE> WITH CHECK OPTION) VALUES(...)for example:CREATE TABLE sharon_test(ID NUMBER, NAME VARCHAR2(20), TYPE VARCHAR2(20));INSERT INTO(SELECT ID, NAME, TYPE FROM sharon_test WHERE ID < 10 WITH CHECK OPTION) VALUES(9, 'test', 'test');这种语法看起来很特殊,实
阅读全文
posted @ 2012-04-23 11:10