ORACLE 12c 创建始终生成列主键
1.GENERATED ALWAYS AS IDENTITY 模式
CREATE TABLE TB_TEST(
id NUMBER GENERATED ALWAYS AS IDENTITY,
name varchar(100)
)
此时插入主键报错,去掉主键成功
2.GENERATED BY DEFAULT AS IDENTITY模式
CREATE TABLE TB_TEST2(
id NUMBER GENERATED BY DEFAULT AS IDENTITY,
name VARCHAR
原创
2020-07-16 17:51:45 ·
319 阅读 ·
0 评论