摘要:
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');这种语法看起来很特殊,实 阅读全文