SQLD · 제60회 · 43번

CREATE TABLE T (
  ID  NUMBER GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1),
  VAL NUMBER CHECK (VAL > 0)
);

INSERT INTO T(VAL) VALUES (-1);
INSERT INTO T(VAL) VALUES ( 0);
INSERT INTO T(VAL) VALUES ( 1);
COMMIT;

SELECT COUNT(*) FROM T;