复制Example： Create table t1 (id int generated always as identity (start with 100 increment by 1),自增字段description char(10)）; Commit; Insert into t1 values (default,’a1’); //insert100 a1 Insert into t1(description) values (’a1’); //insert101 a1 Insert into t1 values (200,’a1’); //erro Commit; Insert into t1(description) values (’a1’); //insert102 a1 Rollback; Insert into t1(description) values (’a1’); //insert103 a1 Commit; Select * from t1; 100 a1 101 a1 103 a1 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16. |
喜欢
讨厌